http://blog.redjini.com/282
startTime ps -eo pid,lstart,cmd | grep -v 'grep' | grep {프로세스아이디, 프로세스명 등 유니크한 값} | awk '{print $5}' ex) ps -eo pid,lstart,cmd | grep -v 'grep' | grep bobobo.war | awk '{print $5}' runningTime ps -eo pid,etime,cmd | grep -v 'grep' | grep {프로세스아이디, 프로세스명 등 유니크한 값} | awk '{print $2}' ex) ps -eo pid,etime,cmd | grep -v 'grep' | grep bobobo.war | awk '{print $2}'
cmd> lsnrctl status TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=User)(PORT=1521))) TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object..
--테이블 락 LOCK TABLE 테이블명 IN EXCLUSIVE MODE; --락이 걸린 테이블 확인 select * from v$locked_object where oracle_username = '사용자명'; --락이 걸려있는 테이블 갯수 확인 select count(*) from v$locked_object vo , dba_objects do where vo.object_id = do.object_id; --락 걸린 세션 확인 select a.sid, a.serial# from v$session a, v$lock b, dba_objects c where a.sid=b.sid and b.id1=c.object_id and b.type='TM'; --락이 걸린 테이블명을 알고 있는 경우 select ..