Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> shared pool latch

shared pool latch

From: Sultan Syed <ssyed_at_fine.ae>
Date: Wed, 31 Mar 2004 14:21:28 +0400
Message-ID: <003b01c41709$edb78b70$05000081@SULTAN1>


Hi guys
The following questions are confusing me,please could someone give explanation on the below

1)Is librarycache latch held during the whole process of parse,execute and fetch phases , or it is held upto the time searching for the object in hash table and release.

2)session_cached_cursor caches the child cursor or parent cursors also.

3)While doing hard parse which latch is acquired ,shared pool or library cache latch or both, if it is both which latch will be acquired first?

Thanks in advance
Syed



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Mar 31 2004 - 04:18:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US