세션 상태 조회하기

set lines 400
col ipaddr for a20
col status for a10
col prog_name for a20
col osuser for a10
col machine for a10
col username for a20
col logon_time for a10
select sid, pid, serial#,  USERNAME, IPADDR, STATUS, STATE,
PROG_NAME, OSUSER, MACHINE, LOGON_TIME, WAIT_TIME
from v$session
order by prog_name, logon_time
/

set lines 400
col ipaddr for a15
col status for a10
col prog_name for a20
col osuser for a10
col machine for a10
select INST_ID, sid, pid, serial#,  IPADDR, STATUS, STATE, PROG_NAME,
OSUSER, MACHINE, LOGON_TIME, WAIT_TIME from gv$session
/

파라미터 조회

set lines 300
col name for a50
col dflt_value for a20
col value for a20
col range for a30
select name, type, dflt_value, value, range
from sys._vt_parameter
--where is_hidden=1
where name in ('_ENABLE_AUTO_COMMIT_WITH_QUERY')
/

col name for a30
col value for a10
select NAME, VALUE
from sys._vt_parameter
where name in ('_USE_CR_CACHE')
/

select name, type, dflt_value, value
from sys._vt_parameter
where name = '_ENABLE_ISS'
/

invalid obect 확인

set lines 300
col owner for a10
col object_type for a20
col object_name for a40
select owner, object_name, object_type, status
from dba_objects
where status = 'INVALID'
/

select owner, table_name, column_name, data_type
from dba_tab_columns
/