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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).