RE: Row cache locks on INSERTs with a sequence

If I stated dc_segments in my original post, I apologize, I *did* mean to say
dc_sequences. At any rate, as usual, the problem was poor application code.
The row cache lock no longer shows up as one of the top 5 wait events per statspack.

And of course, the programmers never apologized, or even deigned to acknowledge
appreciation in improving their application, they are simply acting as offended
cats will do, as though the DBA team doesn't exist.

-----Original Message-----
Sent: Friday, December 20, 2002 11:09 PM To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Jeff
  INET: ThomasJe_at_tce.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).