iT-folder IT関連情報を配信
Oracle/PLSQL: Oracle System Tables

DBA_USERSの参照:
select USERNAME,ACCOUNT_STATUS from DBA_USERS;

SYSDBA/SYSOPER権限ユーザの確認:
select * from v$pwfile_users;

Check privileges by table name:
select * from dba_tab_privs where table_name = 'xxxxxx';

Checking the owner of table:
select owner, table_name from dba_tables where table_name = 'xxxxxxxx';

Search the column
select owner, table_name, column_name from dba_col_comments where column_name like '%xxxxx%'; (CAPITAL)

Checking the value of timed_statistics:
select value from v$parameter where name = ‘timed_statistics’;

Check SQL values:
SELECT
a.sql_text,
b.name,
b.position,
b.datatype_string,
b.value_string
FROM
v$sql_bind_capture b,
v$sqlarea a
WHERE
b.sql_id = a.sql_id