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 can cause multiple child cursors). As per documentation , REASON column has been introduced in 11.2.0.2 REASON – CLOB Child number, id, and reason the…
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 was at 1AM my time and I was sleeping], now viewing this webcast HERE Kerry Osborne has shared information about this product, click link to…
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 which process is using how much memory and how to interpret the output of commands like: vmstat, svmon, ps on AIX. Also, to get more…
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 to 11.1.0.7 from 10.2.0.4. The syntax of the query is like: select max(a) from t1 where c1<>'abc' and c2=12345 and c3='Y' and c4='xyz'; This query…
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 articles for week. So I decided to tag few articles posted in October 2010 which I had read and found useful. I am subscribed to…
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 minutes. We did some quick check’s to narrow down the problematic area.i.e Is it network or database server or some issue with application server? 1)Vmstat…