Oracle - System_Table_List

[ Oracle - System_Table_List ]

 

1. constraint_name  : constraint 즉 forign key 리스트

    user_constraints :

 

2. V$SGA,    V$INSTANCE,     V$PARAMETER,      V$SESSION,     V$OPTION,      V$VERSION,      V$PROCESS

    

   

   

      http://www.databaser.net/oracle/often_ref_dictionary.htm  

 

-- 테이블 정보보기

--예)

SELECT

      A.TABLE_NAME

     , C.COMMENTS

     , A.COLUMN_NAME

     , A.DATA_TYPE

     , A.DATA_LENGTH

     , B.COMMENTS

     , A.COLUMN_ID

FROM DBA_TAB_COLUMNS A, DBA_COL_COMMENTS B, DBA_TAB_COMMENTS C

WHERE A.TABLE_NAME = B.TABLE_NAME

AND A.TABLE_NAME = C.TABLE_NAME

AND B.TABLE_NAME = C.TABLE_NAME

AND A.COLUMN_NAME = B.COLUMN_NAME

 

 

--

 

select  b.status, b.server, b.schemaname, b.osuser, b.machine, b.program, c.spid

from    v$session b, v$process c

where   b.schemaname = 'HRMS'

and     b.paddr = c.addr

and     b.sid in (select distinct sid from v$lock);

 

select b.sid, b.username, b.machine, b.process, b.program, a.sql_text

from   v$sql a, v$session b

where  a.address = b.sql_address

and    a.hash_value = b.sql_hash_value

and    b.sid in ('79');