인성장

Lock Table & Session 해결 절차  1. 오래 수행되는 SQL 조회 (E_Time : SQL문이 수행중인 시간)select sid,serial#,username,program, event,(sysdate-sql_exec_start)*86400 E_Time,sql_id from v$session where status='ACTIVE' and username is not null order by 6 desc; 2. Lock Table 조회set line 200set pages 300col object_name for a15col owner for a10col object_type for a10SELECT DO.OBJECT_NAME , DO.OWNER , DO.OBJECT_T..