V$SQL_SHARED_CURSOR in 11.2.0.2

Oracle 11.2.0.2 has introduced new column "REASON" to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue (11.2.0.2 seems to have too many bugs which…

Continue Reading V$SQL_SHARED_CURSOR in 11.2.0.2

ORA-01722 with Full Table Scan

My application developers approached me with an issue which is very unique to me. They were complaining about a query which was failing with ORA-01722 "invalid number" after an upgrade…

Continue Reading ORA-01722 with Full Table Scan

October 2010 Blogroll Report

It's been time since we saw log-buffer edition with last being published on 1st October 2010 and  Coskan's weekly blogroll report I found them really useful to read top blog…

Continue Reading October 2010 Blogroll Report