Re: Row cache locks on INSERTs with a sequence

On the information as supplied you are correct, the sequence does seem to be the most likely problem.

It has occurred to me, though, that the original poster showed us a couple of lines from v$session_wait - without showing the STATE (or is it STATUS) column.

It is a common error to assume that v$session_wait is showing a wait time - however if the STATE is __not__ "WAITING" then the SECONDS_IN_WAIT column is the time since the last wait ended. So perhaps the OP was seeing lots of 'latch wait' recorded as the previous wait whilst the system was busy burning CPU on something else.

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-----
>From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 20 December 2002 21:11
>Subject: RE: Row cache locks on INSERTs with a sequence
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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