| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Row cache locks on INSERTs with a sequence
You are waiting on locks for the dictionary cache dc_sequences (cache id = 13).
Increasing how many sequences are cached may not help. If sequence caching were the problem, you would seen waits for latch free event (for sequence cache).
Increasing shared pool size may help.
-----Original Message-----
Sent: Friday, December 20, 2002 8:45 AM
To: Multiple recipients of list ORACLE-L
We are continually seeing sessions hanging on row cache locks, which in turn appear to be on dc_segments:
SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3
----- ----------------- ---------- -- -------- -- --------- ---- 29 row cache lock cache id 13 mode 0 request 5 105 row cache lock cache id 13 mode 0 request 5
The offending SQL statement is an INSERT of the following form:
INSERT INTO TABLE (A,B,C,D...) VALUES (:b1, :b2, :b3, SEQUENCE.NEXTVAL,..)
The sequence in question has it's cache value set to the default of 20.
The developers keep insisting that it's a shared pool issue. I've researched Metalink and not come up with a whole lot. I've ran statspack and it has rendered advice with respect to the fact that a lot of new sequence values are being acquired, therefore the sequence cache size needs examination.
But it is necessarily the small cache size of a sequence that can cause these locking issues?
Thanks.
Email: jeff.thomas_at_thomson.net
Indy DBA Master Documentation available at:
http://gkmqp.tce.com/tis_dba
Select 'Indy DBA' then 'DBA Web Pages'
--
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). Received on Fri Dec 20 2002 - 11:54:46 CST
 |
 |