| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: latch free - library cache
Smaller shared pool means smaller library cache hash table (fewer entries,
after all), which means less latch hold-time, which should help alleviate
long waits for a library cache latch. The downside is that lots of SQL that
might have been cached won't be. But that's okay (desirable, actually) if
most of your SQL doesn't use bind variables and can't ever be shared anyway.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in London, Reykjavik, Ottawa, Dallas, Washington,
Denver, Sydney
- Visit www.hotsos.com for schedule details...
-----Original Message-----
Michael
Sent: Friday, May 16, 2003 12:37 PM
To: Multiple recipients of list ORACLE-L
Just out of curiousity, why would you take the approach to just lower the shared pool to 200M ? Is there a good reason for this ? Im not saying that lowering the shared pool is a bad idea. Im just curious in you approach to resloving this problem. Could it be that there is another underlying problem that is causing this ?
fwiw, Mike
-----Original Message-----
Sent: Thursday, May 15, 2003 8:51 AM
To: Multiple recipients of list ORACLE-L
100% CPU utilization will cause any running process to be extremely slow finishing what it's supposed to do while holding any needed shared resources.
High cpu utilization could be the cause if the apps need more CPU power than the available or could be symptom of another problem (bad sql, bug, tuning).
My suggestion, if your shared pool is really 800M, lower it to 200M, and see how it performs.
Also that process that eats the CPU time, needs to be investigated, and tuned.
100% cpu utilization can not be reached except having all the CPUs busy all the time.
How many CPU in the server?
Waleed
-----Original Message-----
Sent: Thursday, May 15, 2003 7:22 AM
To: Multiple recipients of list ORACLE-L
CPU utilization was 100 % on the server. In fact we were looking at the top command. From that came to know about one very long running oracle process. Then traced that process to this perticular problem.
~Dilip
ORACLE-L_at_fatcity.com wrote:
What is the cpu utilization of the server?
Waleed
-----Original Message-----
Sent: Wednesday, May 14, 2003 6:37 AM
To: Multiple recipients of list ORACLE-L
Hi List,
DB 8.1.7.4.0 on Sun sparc solaris 2.6
This is oracle applications 11.5.4
One of the program was running for very long time. So checked out
v$session_wait for that perticular session. It was waiting on 'latch free'
and from P2 column and v$latch, found out that it is waiting for library
cache latch.
Now docs says this is related to shared pool fragmentation. So checked
v$sgastat where it showed 38M space free in the shared pool (Total shared
pool is 800 MB). But it didnt throw ORA-4031 and the process was running for
last 17 hours. I looked at v$librarycache and v$latchholder but didn't get
any clue.
At last, I flushed the shared pool but still that session was waiting on
same wait event. Finally I had to kill the session. I am facing this
situation once or twice in production and everytime I can't kill the
session.
Can somebody tell me how should I debug furthur and go to the root cause of the problem. Does this mean I need to increse the shared pool ? CURSOR_SHARING is kept to FORCE.
Thanks,
~Dilip
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com
Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dilip
INET: dilip7772002_at_indiatimes.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com
Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dilip
INET: dilip7772002_at_indiatimes.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Cary Millsap
INET: cary.millsap_at_hotsos.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 16 2003 - 21:21:40 CDT
 |
 |