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).

Reply via email to