shared pool latch

From: Sultan Syed <ssyed_at_fine.ae>
Date: Wed, 31 Mar 2004 09:51:40 +0400
Message-ID: <000a01c416e4$3d15a600$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 Tue Mar 30 2004 - 23:48:48 CST