Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g47g2000cwa.googlegroups.com!not-for-mail From: "Joel Garry" Newsgroups: comp.databases.oracle.server Subject: Re: intermittent library cache pin/lock problems Date: 12 Dec 2005 17:44:24 -0800 Organization: http://groups.google.com Lines: 26 Message-ID: <1134438264.309256.133310@g47g2000cwa.googlegroups.com> References: <4399bc61.174954125@localhost> <1134425403.977444.296680@o13g2000cwo.googlegroups.com> <439dfd1b.267758328@localhost> NNTP-Posting-Host: 67.116.125.178 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1134438269 4749 127.0.0.1 (13 Dec 2005 01:44:29 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 13 Dec 2005 01:44:29 +0000 (UTC) In-Reply-To: <439dfd1b.267758328@localhost> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: g47g2000cwa.googlegroups.com; posting-host=67.116.125.178; posting-account=YRNZ5wwAAAAg-yYjMFwy3FyWUbPiwNdq Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:257618 NetComrade wrote: >I also don't fully understand why the pin would even be needed for sql >statements that appear to be frequently executed and use bind >variables (i've seen a whole bunch of those for the sessions waiting >for library cache pin/load lock) Because that's what the CURSOR_SPACE_FOR_TIME tells it to do. Shared SQL areas need to be pinned as long as anyone is accessing them. >How does one determine if the pool (library cache) is fragmented, or >look for other degradation pointers? I feel there is too much 'magic' >surrounding the shared pool. There isn't much description of >'internals' exactly what latch (children) are needed for what >operation in the documentation. You got that right. https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=61623.1 maybe you are invalidating things somehow? jg -- @home.com is bogus. "If love is blind, why do people like lingerie so much?" - Nick Brooke "What's love got to do with it?" - Tina Turner