This is one of those tipical situation where one is totally lost! On 2/27/06, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote: > > Hello list, > > We have faced a very very strange problem when accessing or desc v$access > table. > > Database : Oracle 9i Rel.2 (9205) > OS : AIX 5.3 JFS2 Filesystem. > CPU = 30+ > No. Connections = 1000+ > > We are facing problem with latch free (cache buffer chains), when the > problem occurs, cpu becomes 0% ideal and we kill some process from > which transaction are coming. > > I just desc v$access from the sql prompt, and strangly, all the > session are started waiting on 'latch free' and this time its was > library cache and when I kill the session which was desc v$access, > then, everything comes normal. > > It was not just an accident, I can still reproduce the same error. > Whatever action I do on v$access, this is causing. If this was a bug, > we have same OS server, same oracle version for another database, > where this doesn't happens. The only differene between these two > databases are just no. of cpus. > > It is really drawing me crazy. Does anyone has experience the same? > > > -- > Best Regards, > Syed Jaffar Hussain > 8i,9i & 10g, OCP DBA > Banque Saudi Fransi, > Saudi Arabia > http://jaffardba.blogspot.com/ > > ---------------------------------------------------------------------------------- > "Winners don't do different things. They do things differently." > -- > //www.freelists.org/webpage/oracle-l > > >