On Oracle
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...
Thursday, April 28, 2011
dbms_session package_memory_utilization
›
Oracle 11g Release 2 extends dbms_session Package by introducing a new Procedure: get_package_memory_utilization to expose memory usage of ...
‹
Home
View web version