RE: Row cache locks on INSERTs with a sequence

 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 <ORACLE-L_at_fatcity.com> 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: kirti.deshpande_at_verizon.com

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: ListGuru_at_fatcity.com (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: Waleed.Khedr_at_FMR.COM

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: ListGuru_at_fatcity.com (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).