Monthly Archives: July 2011

BUG: MSQSUB When Select From V$SQL_PLAN

Workaround does not crash but “some information will be missing”: ORA-07445 [MSQSUB()+32] When Select From V$SQL_PLAN [ID 791225.1] Bug 7022234 is Fixed in 11.2 Patches exist for it on most platforms on top of 10.2.0.4 at the moment of writing … Continue reading

Posted in Uncategorized | Leave a comment

Reverse Engineering: consistent reads, multi versioning, ITL, ora-1555, row level locks, concurency

Here bellow is a draft list of resources and thoughts about how Oracle implements multi versioning. >http://arup.blogspot.com/2011/01/more-on-interested-transaction-lists.html But I had to add this to http://avdeo.com/2008/06/16/interested-transaction-list-itl/ to https://richardfoote.wordpress.com/2010/07/20/index-block-dump-block-header-part-i-editions-of-you/ and https://richardfoote.wordpress.com/2010/07/28/index-block-dump-block-header-part-ii-and-read-consistency-i-cant-read/ to Jonatahn Lewis comments at: http://forums.oracle.com/forums/thread.jspa?messageID=3725660 Jonathan is probably the first … Continue reading

Posted in Uncategorized | Leave a comment