MY COMPASS

SELECT     a.sid, a.serial#, a.username, a.process, b.object_name, a.blocking_session blocker, a.event,     DECODE(c.lmode,2,'RS',3,'RX',4,'S',5,'SRX',8,'X','NO') "TABLE LOCK",     DECODE(a.command,2,'INSERT',3,'SELECT',6,'UPDATE',7,'DELETE',12,'DROP TABLE',26,'LOCK TABLE','UNknown') "SQL",     DECODE(a.lockwait, NULL,'NO wait','Wait') "STATUS",     'alter system kill session '''||a.sid||','||a.serial#||''' immediate;' as kill_command_input     ,A.* FROM     v$session a, dba_objects b, v$lock c WHERE     a.sid=c.sid and b.object_id=c.id1 AND c.type in ('TM','TX');

http://m.blog.naver.com/shadouman/80122594664 STATTYPE_LOCKED 컬럼에 ALL 값이 존재하면 통계정보 생성을 하지 못하게 락이 걸려 있는것이며 값이 없다면 통계정보를 생성할 수 있는 것이다. select OWNER,TABLE_NAME,STATTYPE_LOCKED from dba_tab_statistics WHERE OWNER = 'SCOTT' AND TABLE_NAME = 'EMP'; OWNER                          TABLE_NAME                     STATTYPE_LOCKED ------------------------------ ------------------------------ --------------- SCOTT                           EMP                                ...