RE: difference between child and parent latches?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 22 Mar 2004 09:33:23 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC53@bosmail00.bos.il.pqe>

Ryan,

The main difference is that for latches which there are multiples, such as cache buffers chains, there is only one parent row in v$latch_parent, whereas there is one row per latch in v$latch_children. Also, the statistics are only valid in the corresponding view. Meaning, GETS, SLEEPS, etc are only populated in v$latch_children for those latches where children are present, such as CBC. For those where there's only one, such as shared pool, that data is only populated in v$latch_parent.

-Mark

-----Original Message-----

From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net] Sent: Monday, March 22, 2004 7:54 AM
To: oracle-l_at_freelists.org
Subject: difference between child and parent latches?

I've been looking at v$latch_children and v$latch_parent and I'm having trouble seeing the differences?

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 Mon Mar 22 2004 - 08:31:47 CST