All indexes on the table involved have INI_TRANS=2 and
PCT_FREE=10.
- Original Message ---
To: Multiple recipients of list ORACLE-L <ORACLEL
@fatcity.com>
>What's the initrans for the indexes involved ?
>
>Anjo.
>
>
>Walter K wrote:
>
>> We have an application that is periodically
>> encountering what appears to be a self-deadlock.
Only
>> one session is listed and it holds an exclusive (X)
>> lock and is waiting for a share (S) lock with NO
ROWS
>> waited. I have pasted the deadlock graph at the
bottom-
>> -hopefully it will be legible.
>>
>> Does anyone know how such a lock could be produced?
>> I'd really like to be able to recreate such a
scenario.
>>
>> Thanks!
>> -w
>>
>> Current SQL statement for this session:
>> update ACCOUNT set
>>
ACCOUNT_ID=:ACCOUNT_ID,ACCOUNT_NAME=:ACCOUNT_NAME,LAST_
>>
MODIFIED=:LAST_MODIFIED,CUSTOMER_NODE_ID=:CUSTOMER_NODE
>>
_ID,ACCOUNT_TYPE_ID=:ACCOUNT_TYPE_ID,ACCOUNT_BALANCE=:A
>>
CCOUNT_BALANCE,BALANCE_DATE=:BALANCE_DATE,INVOICE_ID=:I
>>
NVOICE_ID,PREVIOUS_INVOICE_ID=:PREVIOUS_INVOICE_ID,CRED
>>
IT_LIMIT=:CREDIT_LIMIT,UNBILLED_AMOUNT=:UNBILLED_AMOUNT
>> ,ACCOUNT_ACTION_CODE=:ACCOUNT_ACTION_CODE,ACCOUNT_AC
TIO
>> N_DATE=:ACCOUNT_ACTION_DATE where
>> ACCOUNT_ID=:key_ACCOUNT_ID
>> The following deadlock is not an ORACLE error. It
is a
>> deadlock due to user error in the design of an
>> application
>> or from issuing incorrect ad-hoc SQL. The following
>> information may aid in determining the deadlock:
>> Deadlock graph:
>> ---------Blocker(s)--------
---
>> ------Waiter(s)---------
>> Resource Name process session holds waits
>> process session holds waits
>> TX-0007004c-000026bf 34 95
>> X 34 95 S
>> session 95: DID 0001-0025-0002E096 session 95:
>> DID 0001-0025-0002E096
>> Rows waited on:
>> Session 95: no row
>>
>> --
>> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
>> --
>> Author: Walter K
>> INET: ORA1034_at_sbcglobal.net
>>
>> Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
>> San Diego, California -- Public Internet
access / Mailing Lists
>> ----------------------------------------------------
>> 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 FAX:
(858) 538-5051
>San Diego, California -- Public Internet
access / Mailing Lists
>------------------------------------------------------
>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: Walter K
INET: ORA1034_at_sbcglobal.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Thu Jun 06 2002 - 16:33:42 CDT
