From oracle-l-bounce@freelists.org Tue Mar 30 23:48:48 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2V5mmr08598 for ; Tue, 30 Mar 2004 23:48:48 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2V5mlo08593 for ; Tue, 30 Mar 2004 23:48:47 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E8445634A21; Wed, 31 Mar 2004 00:45:17 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22354-98; Wed, 31 Mar 2004 00:45:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 24D2F6349B6; Wed, 31 Mar 2004 00:45:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 31 Mar 2004 00:44:08 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1BA8263497D for ; Wed, 31 Mar 2004 00:44:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23459-29 for ; Wed, 31 Mar 2004 00:44:07 -0500 (EST) Received: from mail.fine.ae (unknown [213.42.71.145]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id B9C4E63497B for ; Wed, 31 Mar 2004 00:44:06 -0500 (EST) Received: from [129.0.0.5] by mail.fine.ae (GMS 9.02.3180/NY4250.00.cb7cc131) with SMTP id eozocaaa for oracle-l@freelists.org; Wed, 31 Mar 2004 09:47:39 +0400 Message-ID: <000a01c416e4$3d15a600$05000081@SULTAN1> From: "Sultan Syed" To: "oracle freelists.org" Subject: shared pool latch Date: Wed, 31 Mar 2004 09:51:40 +0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C41705.C4143330" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2142 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ssyed@fine.ae Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------=_NextPart_000_0007_01C41705.C4143330 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi guys The following questions are confusing me,please could someone give = explanation=20 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 ------=_NextPart_000_0007_01C41705.C4143330 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

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

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

3)While doing hard parse which latch is = acquired=20 ,shared pool or library cache latch or both,

if it is both which latch will be = acquired=20 first?

Thanks in advance
Syed

------=_NextPart_000_0007_01C41705.C4143330-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------