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…
Read Full Recipe
Oracle has introduced it new product: ODA (Oracle Database Appliance) I was not able to join Oracle President Mark Hurd's webcast where he supposed to announce a new Oracle product[It…
Read Full Recipe
While trying to find the amount of physical memory used by oracle process on AIX, I got reference of a document from Metalink: Performance Management Guide It tell us about…
Read Full Recipe
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…
Read Full Recipe
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…
Read Full Recipe
Recently we faced a performance issue, where in sqlplus connection from application server A (AIX 5.3) to Database server DB (different physical server,10gR2 on AIX 5.3) was taking nearly 1-2…
Read Full Recipe