김개발의 생명정보학

Oracle / PLSQL: Oracle System TablesBelow is an alphabetical listing of the Oracle system tables that are commonly used.System TableDescriptionALL_ARGUMENTSArguments in object accessible to the userALL_CATALOGAll tables, views, synonyms, sequences accessible to the userALL_COL_COMMENTSComments on columns of accessible tables and viewsALL_CONSTRAINTSConstraint definitions on accessible tablesALL_..

-- 락걸린 테이블 확인 SELECT DO.OBJECT_NAME, DO.OWNER, DO.OBJECT_TYPE, DO.OWNER, VO.XIDUSN, VO.SESSION_ID, VO.LOCKED_MODE FROM V$LOCKED_OBJECT VO, DBA_OBJECTS DO WHERE VO.OBJECT_ID = DO.OBJECT_ID; -- 해당 테이블에 LOCK 이 걸렸는지. SELECT A.SID, A.SERIAL#, B.TYPE, C.OBJECT_NAME 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' AND C.OBJECT_NAME IN ('TB_CO_GENO');..