v$bgprocess
V$bgprocess:用于查询后台进程的相关信息。SQL> desc v$bgprocess Name ...
V$process
V$process:该视图用于显示正在活动的进程,SQL> desc v$process; Name &...
V$shared_pool_advice学习
V$shared_pool_advice学习V$shared_pool_size...
dba_segments学习
dba_segments:存储数据库中多有对象占有的段信息。SQL> desc dba_segments; Name &nbs...
查看oracle的隐含参数
我们在查看内存参数时会看到如下执行计划:SQL> set autotrace traceonlySQL> select * from v$parameter;342 rows selected.Execution Plan------------------------------------------------------...