asked on

locked package in pl/sql developer

I am compiling a package xxxx using pl/sql developer and getting the error

"ORA-04021 Timeout occurred while waiting to lock object xxxx"

I just can?t pass that message and get to compile it ..

any idea?
1-It happened to me several days ago and despaired by itself ...
Thanks
Orna

gvalencia

Probably, While you are trying to compile your package, it is being used by another session.

Execute this select statement to determine wheter the package is locked or not. If so you'll see it in column object_name.

select
vs.SID ,
vs.SERIAL# ,
uo.OBJECT_NAME ,
uo.OBJECT_TYPE ,
uo.OBJECT_ID ,
substr( vs.USERNAME, 1, 20 ) USERNAME ,
vs.STATUS ,
vs.SCHEMANAME ,
substr( vs.OSUSER, 1, 20 ) OSUSER ,
vs.MACHINE ,
vs.TERMINAL ,
vs.PROGRAM ,
vs.TYPE
from
v$session vs,
v$locked_object vlo,
all_objects uo
where
vlo.object_id = uo.object_id
and vs.process = vlo.process;

ofarzalla

ASKER

I tried to run the select but getting
v$locked_object does not exist
???

dda

This select is intended to be run under 'sys' user.

ASKER CERTIFIED SOLUTION

Wadhwa

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial