Tuesday, May 23, 2006

Запросы для вывода списка представлений V$

Запросы для вывода списка представлений V$
select * from dictionary where table_name like 'V$%';
select * from dba_views where view_name like 'V_$%';

• V$PARAMETER: To locate the trace file for USER_DUMP_DEST
• V$PROCESS: To find the process ID
• V$SESSION: To correctly identify your session’s information in the other views
• V$INSTANCE: To get the ORACLE_SID

No comments: