检查那些表或者包被锁了

编译失败 由于包被锁了：

Error:ORA-04021: timeout occurred while waiting to lock object 

--check Package locked by some se

select s.SID, s.SERIAL# , s.USERNAME,s.MACHINE , s.OSUSER FROM V$ACCESS A, V$SESSION s WHERE A.SID=s.SID and a.OBJECT = 'package_name' and a.TYPE = 'PACKAGE';

--Block Table

select s.SID,s.SERIAL#,c.SQL_TEXT, s.OSUSER 
from v$locked_object a, v$session s, v$sqlarea c
where a.SESSION_ID = s.SID
and s.SQL_ADDRESS = c.ADDRESS
and c.sql_text like '%table_name%';

;

kill session

alter system kill session 'SID,SERIAL#';

alter system kill session '217,61285';

alter system kill session '441,25411';

V$ACCESS

V$ACCESS displays information about locks that are currently imposed on library cache objects. The locks are imposed to ensure that they are not aged out of the library cache while they are required for SQL execution.

Column	Datatype	Description
SID	NUMBER	Session number that is accessing an object
OWNER	VARCHAR2(64)	Owner of the object
OBJECT	VARCHAR2(1000)	Name of the object
TYPE	VARCHAR2(24)	Type identifier for the object