RE: Lock on a sequence

Thanks, Anjo..
Me bad...
Not sure why I said 'enqueue latch' :(

Yes, it is SQ enqueue.

• Kirti

-----Original Message-----
Sent: Monday, September 23, 2002 3:03 PM To: Multiple recipients of list ORACLE-L

Just want to be picky. It is the SQ enqueue not the latch. There is an SQ enqueue for each sequence. Increasing the cache size will help.

Anjo.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 23, 2002 9:14 PM

> For incrementing sequence number, Oracle has to use an SQ enqueue latch.
To
> minimize the need for this latch, you can increase the cache size for the
> Sequences. Additionally, you can also consider KEEPing the Sequence number
> in Shared pool using dbms_shared_pool.keep() package procedure.
>
> - Kirti
>
> -----Original Message-----
> Sent: Monday, September 23, 2002 12:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello List,
>
> I have a need to try an replicate a problem that has occured on our
> production
> environment. It seems that occassionally our response time dives to the
> buttom
> of the barrel in regards to our tuxedo application. When this occurs we
> have
> found that many of the blocked sessions are trying to query a sequence.
>
> select my.sequence_list.next_value from dual
>
> Does anyone know a possible cause for a sequence to be locked?
>
> Does anyone know how to lock a sequence?
>
> Thanks ahead of time.
>
> Tim Boles
> DBA
> Lockheed Martin Information Systems
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: timboles_at_citynet.net
>
> 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.com
> --
> 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.com
-- 
Author: Anjo Kolk
  INET: Anjo_at_oraperf.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.com
-- 
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).