| deadlock deteced why? [message #159954] |
Wed, 22 February 2006 06:15 |
umberfatima
Messages: 3
Registered: December 2005
Location: Karachi
|
Junior Member |
|
|
i have my database verison : 9.2.0.4 after patchset applied.
below query run fine in oracle 10g,9.1,8.0.5,8.1.7 but fails and deadlock detected in 9.2.0.4 .
Please let me know why this occur in oracle patched version ?
Amber Fatima.
-----------------------------------------------------
SELECT GRANTEE, PRIVILEGE, ADMIN_OPTION
FROM sys.dba_sys_privs
WHERE (PRIVILEGE LIKE '%ALTER ANY%') AND
(ADMIN_OPTION = 'NO') and
grantee not in ( select USERNAME from v$PWFILE_USERS
WHERE SYSDBA = 'TRUE' OR SYSOPER = 'TRUE' )
)
-----------------------------------------------------
Dump file f:\oracle\admin\ses\udump\ses_ora_2068.trc
Wed Feb 22 16:57:11 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: ses
Redo thread mounted by this instance: 1
Oracle process number: 11
Windows thread id: 2068, image: ORACLE.EXE
*** 2006-02-22 16:57:11.187
*** SESSION ID:(11.68) 2006-02-22 16:57:11.125
DEADLOCK DETECTED
Current SQL statement for this session:
SELECT GRANTEE, PRIVILEGE, ADMIN_OPTION
FROM sys.dba_sys_privs
WHERE (PRIVILEGE LIKE '%ALTER ANY%') AND
(ADMIN_OPTION = 'NO') and
grantee not in ( select USERNAME from v$PWFILE_USERS
WHERE SYSDBA = 'TRUE' OR SYSOPER = 'TRUE' )
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
PF-00000000-00000000 11 11 X 11 11 X
session 11: DID 0001-000B-0000000E session 11: DID 0001-000B-0000000E
Rows waited on:
Session 11: no row
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
*** 2006-02-22 16:57:11.343
ksedmp: internal or fatal error
ORA-00060: deadlock detected while waiting for resource
Current SQL statement for this session:
SELECT GRANTEE, PRIVILEGE, ADMIN_OPTION
FROM sys.dba_sys_privs
WHERE (PRIVILEGE LIKE '%ALTER ANY%') AND
(ADMIN_OPTION = 'NO') and
grantee not in ( select USERNAME from v$PWFILE_USERS
WHERE SYSDBA = 'TRUE' OR SYSOPER = 'TRUE' )
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+327 CALLrel _ksedst+0
..1.16_4.except.112 CALLrel _ksedmp+0 3
+80
..1.17_5.filter.112 CALLrel _ksqded.112+0 676EC42C 676EC418 0 1
+558
_ksqgtl+1530 CALLrel _ksqcmi.112+0
_ksqgel+550 CALLrel _ksqgtl+0 676EC418 6 0 384 1C482F4 0 0
10 0 0
_kzsrcbk+108 CALLrel _ksqgel+0 6763D804 6 0 384 1C482F4 0 0
10 0 0
_qerfxFetch+1658 CALLreg 00000000
_subex1+142 CALL??? 00000000 693B21E4 0 0 1 693B21E4 1
_subsr3+151 CALLrel _subex1+0 BD3C914
..1.42_2.filter.9+5 CALL??? 00000000 693B059C
16
_expepr+417 CALLrel _evaopn2+0 693B3AF0
_expeal+47 CALLrel _expepr+0 693C24A4
_qerflFetchOutside+ CALLrel _expeal+0 693C24E8
91
_qergsFetch+439 CALL??? 00000000
_qerflFetchOutside+ CALL??? 00000000
73
..1.3_1.filter.30+7 CALL??? 00000000 693B2248 A12BF0 BC6DAEC 1
69
_opiall0+2546 CALLrel _opifch2+0 89 5 BC6DDC0
_kpoal8+1532 CALLrel _opiall0+0 5E 22 BC6DEDC 0 BC6DF7C
BCA9EDC FD 24 0 BC6DF68 0 1 0
1290930
_opiodr+1244 CALLreg 00000000 5E 14 BC6E72C
_ttcpip+2554 CALLreg 00000000 5E 14 BC6E72C 0
_opitsk+750 CALLrel _ttcpip+0
_opiino+1547 CALLrel _opitsk+0 0 0 503EDD0 BD0E064 E2 0
_opiodr+1244 CALLreg 00000000 3C 4 BC6FBD4
_opidrv+563 CALLrel _opiodr+0 3C 4 BC6FBD4 0
_sou2o+25 CALLrel _opidrv+0
_opimai+266 CALLrel _sou2o+0
_OracleThreadStart@ CALLrel _opimai+0
4+961
7C57B385 CALLreg 00000000
--------------------- Binary Stack Dump ---------------------
----................
................
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
