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...
Monday, November 21, 2011

One Oracle 12g Pre-announce of bug fix in dbms_debug_jdwp

›
4 years ago, I filed a bug of dbms_debug_jdwp in 10gR2, after 2 years of pingpong playing, Oracle finally acknowledged the reproducibility o...
Thursday, November 17, 2011

Oracle 11gR2 single session "library cache pin"

›
Abstract: Recently we encountered a single session cyclic  "library cache pin" during upgrade to 11.2.0.3.0 from a lower versio...
Tuesday, July 19, 2011

Redo/Undo explosion from thick declared table insert

›
This blog presents a Redo/Undo explosion caused by thick declared table insert. Originally there is a thin table (thin_tab) consisting of tw...
Thursday, May 5, 2011

ORA-04027: self-deadlock during automatic validation

›
Sometimes ago I hit an error:    ORA-04027: self-deadlock during automatic validation for object I wonder why there is a self-deadlock i...
Wednesday, May 4, 2011

Foreign Key on Nested Table

›
This Blog will make an attempt to define a referential constraint on a nested table column. At first I copy and run the code from Book: Ex...
Monday, May 2, 2011

Update Restart and new Active Undo Extent

›
Blog:  That old restart problem again... ( http://tkyte.blogspot.com/2010/04/that-old-restart-problem-again.html ) or Link: That old rest...