Author Archives: Bobby

I had worked on creating a Delphix virtual copy of our production PeopleTools 8.53 database and wanted to use ENCRYPT_PASSWORD in Datamover to change a user’s password. But I got this ugly error: Error: Process aborted. Possibly due to JVM is … Continue reading →

A project team asked me to look at the performance of an Oracle database application that does a bunch of inserts into a table. But, when I started looking at the AWR data for the insert the data confused me. The … Continue reading →

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 →