i'm still having trouble understanding what the real difference is between a parent latch and a child latch? > > From: K Gopalakrishnan <kaygopal@xxxxxxxxx> > Date: 2004/03/23 Tue AM 04:28:38 EST > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: difference between child and parent latches? > > Paul: > > You will have only one latch if your shared pool is less than 250 MB. > But the v$latch_children may (probably) have 7 entries, but only one > latch will be protecting the shared pool structures. This can be > verified by checking the misses/sleeps for that particular child. > > Regards, > Gopal > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------