On Oracle
Friday, December 7, 2012
Delete Restart and new Active Undo Extent
›
Oracle dbms_lock.allocate_unique allocates a unique lock ID to a named lock, and returns the handle associated with the lock ID so that ap...
Wednesday, November 21, 2012
One Oracle AQ Deadlock
›
A few days ago, an AQ based Oracle application (Oracle 11.2.0.3.0) threw a deadlock after more than 1,000,000 times of unobstructed running ...
Friday, November 16, 2012
Oracle Java OutOfMemoryError
›
A long time perplexed issue is that a Java stored procedure in Oracle throws a java.lang.OutOfMemoryError very seldom, once a couple of mon...
Monday, July 30, 2012
One Mutex Collision Test
›
Inspired by the recent Higgs boson-hunting experiments at CERN, this Blog is trying to make some Oracle Mutex collision test on Oracle 11.2....
Monday, May 7, 2012
Why shared pool is doubled ?
›
Problem: There is an Oracle application which divides the whole work as front-end and back-end. Both are performing the similar tasks....
Tuesday, April 24, 2012
High system time utilization on fast machine
›
Problem: Recently we hit some performance problem on a system running a heavy Oracle application. Occasionally when mor...
Monday, February 20, 2012
Is latch misses statistic gathered or deduced ?
›
Correction (2017-Sep-23): One very experienced Oracle specialist pointed out my error in this Blog. The formula given by Book: Oracle Co...
‹
›
Home
View web version