| 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: severe lib cache contention !!
CURSOR_SHARING is 8.1.6.
"Walking on water and developing software from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Wednesday, July 25, 2001 10:13 AM
To: Multiple recipients of list ORACLE-L
Set your time_statistics=false i think this is a bug in 8.1.5 we had the
same issue.
and also I am not sure whether you can set cursor_sharing=force in 8.1.5 if
yes try this out this will convert all the literals to bind variables
>From: Rahul <rahul_at_ratelindo.co.id>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: severe lib cache contention !!
>Date: Wed, 25 Jul 2001 04:35:25 -0800
>
>list,
>i just ported a system to 8.1.5, the application DOES NOT make use of
>bind variables, each and every query (fired from 8 clients every 2-3
>seconds)
>parses and executes, this keeps the shared pool patch also very busy...
>
>i cannot tune the app, is there something i can do to reduce the lib
>cache and shared pool latch contention ??
>
>v$session_wait show all sessions waiting on "latch free"
>
>the sleeps in lib cache latch are not properly spread out also...
>
>SQL> select * from v$latch_children where latch#=99 order by 8
>
>CHILD# GETS MISSES SLEEPS
>--------------------------------------
> 1 209093 149 117
> 5 283185 602 221
> 6 304797 616 264
> 7 583061 3354 1417
> 4 2697205 191099 33858
> 2 11636488 8683396 980522
> 3 60982875 47012872 8777649
>
>Interestingly, the same app was NOT showing any contention on these
>latches in 7.3.2 !!
>
>how can i solve this problem ?
>
>TIA
>
>Rahul
>
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com -- Author: ARUN K C INET: arun_k_c_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Christopher Spence INET: cspence_at_FuelSpot.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Wed Aug 01 2001 - 08:52:28 CDT
 |
 |