本文共 1589 字，大约阅读时间需要 5 分钟。

select owner,object_id,data_object_id,status from dba_objects  where object_name=upper('t_sdp_dnagroupinfo'); select * from v$logfile; select * from dba_extents where segment_name='T_USERSENDLIMIT' ---扩展段 select sum(t.blocks) , owner from dba_extents t group by t.owner having sum(t.blocks) > 130000;    select sum(pins),sum(reloads) ,sum(reloads)/sum(pins)*100 from v$librarycache; select sum(gets),sum(getmisses),sum(getmisses)/sum(gets)*100 from v$rowcache; --基本数据字典表 select * from v$parameter where name like 'db_block_size%';---数据库参数信息 select dbid,log_mode from v$database;-----查询当前数据库是否为归档模式 select * from dba_tables where owner='PROM_C50';----所有有的表信息 select * from dba_tab_columns;----所有有的列信息 select * from dba_ind_columns where index_owner='PROM_C50';---所有有的索引信息 select * from dba_segments  where bytes >1*1024*1024*1024;--所有用户段使用的表空间的信息 --数据库组件相关表 select * from v$database;---数据库信息 select * from dba_tablespaces; --表空间相关 select * from dba_data_files; select * from dba_free_space; select * from v$filestat; select * from v$datafile; select * from v$log;---日志相关 select * from v$thread;--日志线程基本信息 select * from v$logfile;--日志文件概要信息 select * from v$archived_log;--归档日志文件基本信息 select * from v$archive_dest;--归档日志文件路径基本信息 select * from v$instance;--实例基本信息 select * from v$parameter;--系统各个参数基本信息 select * from v$system_parameter;--当前实例有效信息 select * from v$SGA;--内存结构 select * from V$sgastat; select * from v$db_object_cache;--记录缓存大小信息 select * from v$sql;--SQL语句详细信息 select * from v$sqltext;--记录sql语句的信息 select * from v$sqlarea;-- select * from v$bgprocess;--后台进程 select * from v$session;--会话

转载地址：http://sofkp.baihongyu.com/