severe lib cache contention !!

From: Rahul <rahul_at_ratelindo.co.id>
Date: Wed, 25 Jul 2001 04:39:13 -0700
Message-ID: <F001.003543C8.20010725043525@fatcity.com>

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). Received on Wed Jul 25 2001 - 06:39:13 CDT