shared pool size / library cache locks / too big ?
From: <Christopher.Taylor2_at_parallon.net>
Date: Sun, 2 Jun 2013 12:21:51 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A03A5F69_at_NADCWPMSGCMS10.hca.corpad.net>
Env: 10.2.0.4 3-node RAC.
I've been reading a bit online about library cache lock waits and ran across a forum reply by Charles Hooper in discussion about session_cached_cursors and libary cache locks and it was discussed that perhaps the shared pool was oversized.
Date: Sun, 2 Jun 2013 12:21:51 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A03A5F69_at_NADCWPMSGCMS10.hca.corpad.net>
Env: 10.2.0.4 3-node RAC.
I've been reading a bit online about library cache lock waits and ran across a forum reply by Charles Hooper in discussion about session_cached_cursors and libary cache locks and it was discussed that perhaps the shared pool was oversized.
I'm curious what symptoms/indicators (besides library cache lock waits) I can look into to determine if our shared pool (~22GB) is oversized and/or increase session cached cursors (20 currently)? The app is very immature and a mix of SQLs using binds and literals.
Chris Taylor
Oracle DBA
Parallon IT&S
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jun 02 2013 - 19:21:51 CEST