No question at this time
DBA Top 10
1 A. Kavsek 10900
2 M. Cadot 6200
3 P. Wisse 5000
4 B. Vroman 4500
5 T. Boles 2200
6 . Lauri 2000
7 J. Schnackenberg 1300
8 J. PĂ©ran 1100
9 R. Pattyn 700
10 T. P 500
10 G. Graham 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48425
Total active users1512
Act. users last 24h8
Act. users last hour0
Registered user hits last week172
Registered user hits last month818
Go up

ORA-04021: timeout occurred while waiting to lock object
Next thread: How one node became master for database blocks
Prev thread: File Empty

Message Score Author Date
Hi Guys How do I see who holds a lock on create...... Tso P Oct 16, 2018, 14:34
Hi Tso, The SESSION_ID column matches SID from ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Philip Wisse Oct 17, 2018, 09:20
Thanks Philip... Tso P Oct 17, 2018, 09:51

Follow up by mail Click here


Subject: ORA-04021: timeout occurred while waiting to lock object
Author: Tso P, South Africa
Date: Oct 16, 2018, 14:34, 338 days ago
Os info: solaris 10
Oracle info: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Message: Hi Guys

How do I see who holds a lock on create or replace from dba_ddl_locks. I get about 10 sessions but I don't see which one have a block on create or replace.

Thanks for the help !!!

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ORA-04021: timeout occurred while waiting to lock object
Author: Philip Wisse, Netherlands
Date: Oct 17, 2018, 09:20, 338 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi Tso,

The SESSION_ID column matches SID from v$process:
https://tedstruik-oracle.nl/ords/f?p=25384:1067:::NO:::

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ORA-04021: timeout occurred while waiting to lock object
Author: Tso P, South Africa
Date: Oct 17, 2018, 09:51, 338 days ago
Message: Thanks Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here