Category Archives: Uncategorized

I was googling for things related to NOLOGGING operations and found this useful post on the Ask Tom web site: url There is a nice table in the post that shows when insert operations generate redo log activity. But it … Continue reading →

I am working on a production issue. I do not think that we have a database issue but I am graphing some performance metrics to make sure. I made a new graph in my PythonDBAGraphs program. It shows the average number … Continue reading →

A coworker passed a test script on to me that was failing with the following memory error: ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link) The error occurred when initializing a PL/SQL table variable … Continue reading →

Today I finally finished the Mathematics for Computer Science class that I have worked on since December. For the last year or two I have wanted to do some general Computer Science study in my free time that is not directly … Continue reading →

I have been using  VMware Player to build test virtual machines on my laptop with an external drive for some time now. I used to use the free VMware Server. My test VMs weren’t fast because of the slow disk drive but they … Continue reading →

Still tweaking my Python based Oracle database performance tuning graphs. I kind of like this new version of my “sigscpuio” graph: The earlier version plotted IO, CPU, and Elapsed time summed over a group of force matching signatures. It showed … Continue reading →

I made a new graph in my PythonDBAGraphs program. Here is an example with real data but the database name blanked out: My graphs are all sized for 1920 x 1080 monitors so I can see all the detail in … Continue reading →

We are moving a production database from 10.2 Oracle on HP-UX 64 bit Itanium to 11.2 Oracle on Linux on 64 bit Intel x86. So, we are upgrading the database software from 10.2 to 11.2. We are also changing endianness … Continue reading →

The developers complained that their test database was so much slower than production that they could not use it to really test whether their batch processes would run fast enough when migrated to production. They did not give me any … Continue reading →

I am finally getting around to finishing my four-part blog series on people who have had the most influence on my Oracle performance tuning work. The previous three people were Craig Shallahamer, Don Burleson, and Cary Millsap. The last person is Jonathan Lewis. … Continue reading →