RE: difference between child and parent latches?
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 22 Mar 2004 06:47:22 -0800 (PST)
Mark:
> as CBC. For those where there's only one, such as shared pool, that
> data is only populated in v$latch_parent.
>
> -Mark
Not quite true. (at least starting from 9i). The shared pool is divided
in to multiple sub-pools if it is greater than 250MB and/or if your
cpu_count > 4. In this case the shared pool is covered by multiple
shared pool latches.
Regards,
K Gopalakrishnan
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
