OraChat – Oracle DBAs

This post is from one of the emails I have recieved from my friend Mackenzie D’Cruz, he experienced this issue on his production environment. This information is published by Don Burleson at http://www.dba-oracle.com. So this is just a copy to let our readers know about this issue. Beware, following new upgrades to 11gR2, you can […]

For any performance tuning issue, our strategy in diagnosing the problem is to take a “top-down” approach and follow the trail of highest CPU consumption down to the offending processes, and eventually the offending sessions and query. Verify CPU Consumption on the server is the first step any DBA should do for a top-down approach […]

Globally busy buffers due to contention for index leaf and branch blocks As we discussed in previous sessions, because of batch INSERT high concurrency could occur for a relatively small set of index leaf and branch blocks, where index keys are populated with monotonically ascending values.The symptoms are increased frequencies and wait times for a […]

If you conducted an import or export of an Oracle10g Release 2 or 11g Release 1 database prior to September 11, 2009, you should follow the instructions in My Oracle Support Knowledge Document 1055539.1 to verify the privileges in your database. This is because a missing step in several OracleMetaLink notes published before 11 September […]