You are nice person. I still think the problem was mainly a sequence problem.
regards, Waleed -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 12/20/02 9:43 PM And I was unlucky :( Cache id 13 is dc_sequences on 8i and 9i versions of oracle, so I guessed shared pool shortage, if latch waits did not point to SQ enqueue... - Kirti -----Original Message----- Sent: Friday, December 20, 2002 3:39 PM To: Multiple recipients of list ORACLE-L It matches to the cache# in v$rowcache. I have to say that I seem to have got to a suitable conclusion by mistake. The OP quoted cache id 13, and said it references dc_segments - hence my suggestion about small extents. In fact cache id = 2 is dc_segments, and cache id = 13 is dc_sequences (at least on my 9.2 system - the values may vary across version). I based my comments on dc_segments - not on the cache id number - still, I got lucky ! Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____England______January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -----Original Message----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 20 December 2002 21:11 >What does it mean "cache id 13" ? > >Regards, > >Waleed > >-----Original Message----- >Sent: Friday, December 20, 2002 2:29 PM >To: Multiple recipients of list ORACLE-L > > > >If the wait times on the latch were significant, I >think I'd check that the inserts were high volume >inserts into tables with a very small extent >sizes and lots of indexes, also with very small >extents. > >I wouldn't have thought it was anything to do >with sequences. > > >Regards > >Jonathan Lewis >http://www.jlcomp.demon.co.uk > >Coming soon a new one-day tutorial: >Cost Based Optimisation >(see http://www.jlcomp.demon.co.uk/tutorial.html ) > >Next Seminar dates: >(see http://www.jlcomp.demon.co.uk/seminar.html ) > >____England______January 21/23 > > >The Co-operative Oracle Users' FAQ >http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
