学习动态视图(序)

一直想让自己习惯在没有Toad的情况下工作，尽可能多的熟悉动态视图，可往往都半途而废。今天留个脚印，非紧急状况不使用工具，就SQLPlus！

关于动态视图这个命题已经被提很多遍了，学习动态视图，就从它开始了！根据前人的经验，初定了一个学习计划，罗列于此，也算是给自己一点学习的动力：
v$sysstat + v$sesstat
v$session
v$process
v$sql + v$sqltext + v$sqlarea
v$bh + x$bh
v$lock
v$latch + v$latch_children
v$system_event
v$transaction
V$filestat

===========================================================

V$views are dynamic performance views based on the X$tables. Query V$FIXED_VIEW_DEFINITION for definitions of V$views. V$views are owned by SYS and are public synonyms for corresponding V_$views. V$views are cumulative in nature tracking information since startup. V$ & GV$ views are created from $ORACLE_HOME/rdbms/admin/catalog.sql. Grant access to the V$_views or GV$_views and instruct users to access the views prefaced with SYS.

Only differance between GV$ and V$ views is the instance ID column. Ensure timed_statistics = TRUE for collection of all needed information.
Replication, RAC, Streams, Heterogeneous Services, Logical Standby and Other Views here

For a complete list of the v$views use one of the three querys below:
select kqfvinam name from x$kqfvi order by kqfvinam;
select * from PUBLICSYN where sname like 'V$%' order by 3,1;
select table_name from DICTIONARY where table_name like 'V$%' order by 1;

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/55472/viewspace-311543/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/55472/viewspace-311543/