Got a report (oracle report) that uses dynamic_sql, the procedure name is get_network (defined
inside the report). Since we migrated to 9204 (from 9202), when run from command line it shows a
continuous stream of ora-4020 errors ... here is a snippet. No obvious open bugs found in
metablink.
Since I can't read ora-4020 trace file details, does anyone know what the heck is going on? I
know it is a self deadlock, matches a bug in (me thinks) 817 ... but was (claimed) fixed before
9i.
As I search for more information, please let me know if you know how to resolve these.
Thanks in advance
Raj
===<>===<>===<>===<>===
A deadlock among DDL and parse locks is detected. This deadlock is usually due to user errors in
the design of an application or from issuing a set of concurrent statements which can cause a
deadlock. This should not be reported to Oracle Support.
The following information may aid in finding the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object/Namespace0002/GET_NETWORK
object waiting waiting blocking blocking
handle session lock mode session lock mode
- -------- -------- ---- -------- -------- ----
202829c8 200f819c 2010c1a8 X 200f819c 2010c16c S
- DUMP OF WAITING AND BLOCKING LOCKS ----------
- WAITING LOCK -------------
SO: 2010c1a8, type: 4, owner: 20350430, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2010c1a8 handle=202829c8 request=X
call pin=0 session pin=0
user=200f819c session=200f819c count=0 flags=[00] savepoint=0
LIBRARY OBJECT HANDLE: handle=202829c8
name=/Namespace0002/GET_NETWORK
hash=54c7f2c2
namespace=TABL/PRCD/TYPE flags=SML/[02000000]
kkkk-dddd-llll=0000-0000-0000 lock=S pin=S latch=0
lwt=202829e0[2010c1b8,2010c1b8] ltm=202829e8[202829e8,202829e8]
pwt=202829f8[202829f8,202829f8] ptm=20282a50[20282a50,20282a50]
ref=202829d0[202829d0,202829d0]
LIBRARY OBJECT: object=202827b0
DATA BLOCKS:
data# heap pointer status pins change
- -------- -------- ------ ---- ------
0 20349bcc 0 I/P/A 0 NONE
2 20282868 0 -/P/- 1 NONE
3 202828c8 0 -/P/- 1 NONE
4 20282928 0 -/P/- 1 NONE
- BLOCKING LOCK ------------
SO: 2010c16c, type: 4, owner: 202cbd5c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2010c16c handle=202829c8 mode=S
call pin=2010d1cc session pin=0
user=200f819c session=200f819c count=1 flags=PNC/[04] savepoint=0
LIBRARY OBJECT HANDLE: handle=202829c8
name=/Namespace0002/GET_NETWORK
hash=54c7f2c2
namespace=TABL/PRCD/TYPE flags=SML/[02000000]
kkkk-dddd-llll=0000-0000-0000 lock=S pin=S latch=0
lwt=202829e0[2010c1b8,2010c1b8] ltm=202829e8[202829e8,202829e8]
pwt=202829f8[202829f8,202829f8] ptm=20282a50[20282a50,20282a50]
ref=202829d0[202829d0,202829d0]
LIBRARY OBJECT: object=202827b0
DATA BLOCKS:
data# heap pointer status pins change
- -------- -------- ------ ---- ------
0 20349bcc 0 I/P/A 0 NONE
2 20282868 0 -/P/- 1 NONE
3 202828c8 0 -/P/- 1 NONE
4 20282928 0 -/P/- 1 NONE
===<>===<>===<>===<>===
Best Regards
Raj
select mandatory_disclaimer from company_requirements;
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Jul 01 2004 - 12:41:33 CDT
