Re: Oracle trace syntax help?...ACTIVE sessions..."library cache" waits"?
- From: Chris Marquez <marquezemail@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx, zhuchao@xxxxxxxxx
- Date: Mon, 9 Jan 2006 14:17:15 -0500
>>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
Other related posts:
