Author Archives: Bobby

This morning a colleague of mine noticed an alert from our plan change monitor and prevented any impact on the users by forcing a SQL’s plan to its normal fast plan before the users could be affected.  I want to … Continue reading →

I mentioned this class earlier in a blog post but I wanted to remind people who read this blog that the class is starting again on Wednesday.  Here is the URL for the class: link The class is completely free and … Continue reading →

Development asked me to look at ways to cut the run time of a series of PeopleSoft payroll batch jobs so I took an AWR report of the entire 4 hour period.  Based on the waits, the percentage of the elapsed time … Continue reading →

We keep 6 weeks of history in the AWR on our databases, but I want to capture some information for long-term trending. What I really want to do is capture some metrics and put them in some database tables to … Continue reading →

I applied the current July patch sets to a 11.2 and a 12.1 test database.  Now I have a 11.2.0.4.7 and a 12.1.0.2.4 test database.  It is helpful to have test databases that are on the most current patch sets and … Continue reading →

I registered myself for Oracle OpenWorld and I have my hotel reserved and my flights ticketed. I think it has been over 12 years – probably more like 15 years – since I went to OpenWorld. I went at least once … Continue reading →

I just finished the last program for a computer science class on edX and I urge you to try it. I took this class: MITx: 6.00.1x Introduction to Computer Science and Programming Using Python I was more interested in how MIT taught the class than … Continue reading →

I’m still working on resolving the issues caused by bug 13914613. Oracle support recommended that we apply a parameter change to resolve the issue but that change requires us to bounce the database  and I was looking for a resolution … Continue reading →

I hacked together a query today that shows the overall I/O performance that a database is experiencing. The output looks like this: End snapshot time number of IOs ave IO time (ms) ave IO size (bytes) ——————- ————- —————- ——————- … Continue reading →

Oracle support says we have hit bug 13914613.  Here is what our wait events looked like in an AWR report: Top 5 Timed Foreground Events Event Waits Time(s) Avg wait (ms) % DB time Wait Class latch: shared pool 3,497 17,482 … Continue reading →