oracle系统视图V$
--数据字典表
select * from v$fixed_table;
select * from v$fixed_view_definition;
select * from dictionary;
--基础信息
select * from v$version;
select * from v$license;
select * from v$database;
select * from v$instance;
select * from v$sga;
select * from v$spparameter
select * from v$parameter;
select * from v$sysstat;
--进程会话
select * from v$thread;
select * from v$process;
select * from v$session;
--文件信息
select * from v$controlfile;
select * from v$datafile;
select * from v$logfile;
select * from v$archived_log;
--数据库对象
select * from v$tablespace;
select * from v$transaction
--IO stat
select * from v$segstat;
select * from v$filestat;
select * from v$tempstat;
--Event
select * from V$EVENT_NAME;
select * from v$system_event;
select * from V$SERVICE_EVENT;
select * from V$SESSION_EVENT;
--OWI
select * from V$WAITSTAT;
select * from V$WAIT_CHAINS;
select * from V$SYSTEM_WAIT_CLASS;
select * from V$SERVICE_WAIT_CLASS;
select * from V$SESSION_WAIT_CLASS;
select * from V$SESSION_WAIT;
select * from V$SESSION_WAIT_HISTORY;
select * from V$CHANNEL_WAITS;
--sql信息
select * from v$sql;
select * from v$sqltext;
select * from v$sqlarea;
--lock,latch
select * from v$lock;
select * from v$latch;
--advice
select * from v$db_cache_advice;
select * from v$PGA_TARGET_ADVICE;
select * from v$SHARED_POOL_ADVICE;
--ADR自动诊断库
select * from v$diag_info;
--审计信息
select * from sys.aud$
最新文章
- Python高手之路【四】python函数装饰器
- 网站flash黑屏问题
- [CF #290-C] Fox And Names (拓扑排序)
- IPC——命名管道
- asp.net MVC 中@Html.Partial,@Html.Action,@Html.RenderPartial,@Html.RenderAction区别
- (二)在.net中如何使用Memcached
- web页面的优化
- asp.net mvc生命周期学习
- 八、频繁模式挖掘Frequent Pattern Mining
- Linux+.NetCore+Nginx搭建集群
- php&;amp;&;amp;页面静态化
- MySQL——修改数据库远程权限
- oc之证书
- Tornado-cookie
- 手写实现简单版IOC
- Spring框架学习08——自动代理方式实现AOP
- 纯CSS3冒泡动画按钮实现教程
- django的母板和继承
- Matlab——filter函数用法
- DNA binding motif比对算法