Hi Bing, I meant the case when the load (number of requests) is much higher on a particular latch comparing to over latches
Regards, Ed > When you say uneven, does it mean fragmented? I am learning this too. > > > Bing > > > -----Original Message----- > Sent: Wednesday, October 17, 2001 4:25 PM > To: Multiple recipients of list ORACLE-L > > > Hi List, > > what is the criteria of uneven distribution of sleeps on the library cache > latches? Is there a rule > of thumb to determine uneven distribution? For example, no of sleeps on a > latch is twice bigger than > average no of the sleeps on the others latches? Is it correct? > > Do you estimate the following distribution as uneven? > > NAME GETS MISSES SLEEPS SLEEP1 SLEEP2 > SLEEP3 > -------------- ---------- ---------- ---------- ---------- ---------- > ---------- > library cache 806881977 10346278 3105912 335866 1020725 > 217664 > library cache 464142903 3937558 1318015 154644 422509 > 94864 > library cache 283177601 1991648 1127057 120761 368308 > 80551 > library cache 839438890 7967497 1478426 195907 479182 > 95918 > library cache 978851575 13104596 1614737 213383 527238 > 104408 > library cache 279613950 1453222 759127 77395 255984 > 51334 > library cache 834477709 11623000 3101181 405102 1058753 > 168282 > library cache 260953580 1434471 825151 93505 278275 > 52608 > library cache 470252271 5262933 1484982 162567 489911 > 103336 > library cache 501042073 5134467 1595443 180043 507939 > 119648 > library cache 1265644171 25013169 2374937 371608 754426 > 152126 > > > TIA, > Ed > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Edward Shevtsov > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Wong, Bing > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).