Re: Oracle trace syntax help?...ACTIVE sessions..."library cache" waits"?

From: Chris Marquez <marquezemail_at_gmail.com>
Date: 2006-01-09 20:17:15
Message-id: d494e9760601091117p6700764cj5474f9191d8a9fc1@mail.gmail.com

>>Can you email me a full statspack?

Don't have one now and no issue right now.

>>Check v$sql.first_load_time for new SQLs. If you are not flushing sga
often.
I will when it happens again.

>>use this SQL;
>>so you are aware of the SQLs waiting on some thing.
I have similar SQL...that is how I see all this for many sessions when is happening.

    WAIT_EVENT/LATCH_NAME

---

    latch free/library cache

>>not likely. it should be due to the internal contention.
>>how big is your shared pool?

I think it might be a bit small?
I have found that other than "RELOADS", all of my other library cache Ratio's look good.

Chris Marquez
Oracle DBA Received on Mon Jan 09 2006 - 20:17:15 CST