Re: v$access + latch free(library cache) BUG???

Nope,

There are no dictionary statistics. However, I have raised a TAR and I am going to provide them the dumpstate and hanganalysis traces for further examination.
When I search in the bug database for the same, I found a bug (exactly same) on LINUX OS.

On 2/27/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> Do you have dictionary statistics by any chance? If so I would delete
> them (exec dbms_stats.delete_schema_stats('SYS') ) and see if that
> makes a difference.
>
> At 09:37 AM 2/27/2006, The Human Fly wrote:
>
> >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?
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
>
>

--
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."
--
http://www.freelists.org/webpage/oracle-l