軟件環境: 
  1、Windows NT4.0+Oracle 8.0.4 
  2、ORACLE安裝路徑為:C:/ORANT 
  
  SQL語句: 
  表: 
    select * from cat; 
    select * from tab; 
                                                                                                select table_name from user_tables; 
  視圖: 
    select text from user_views where view_name=upper('&view_name'); 
  索引: 
    select index_name,table_owner,table_name,tablespace_name,status from user_indexes order by table_name; 
  觸發器: 
    select trigger_name,trigger_type,table_owner,table_name,status from user_triggers; 
  快照: 
    select owner,name,master,table_name,last_refresh,next from user_snapshots order by owner,next; 
  同義詞: 
    select * from syn; 
  序列: 
    select * from seq; 
  數據庫鏈路: 
    select * from user_db_links; 
  約束限制: 
    select TABLE_NAME,CONSTRAINT_NAME,SEARCH_CONDITION,STATUS from user_constraints; 
  本用戶讀取其他用戶對象的權限: 
    select * from user_tab_PRivs; 
  本用戶所擁有的系統權限: 
    select * from user_sys_privs; 
  用戶: 
    select * from all_users order by user_id; 
  表空間剩余自由空間情況: 
    select tablespace_name,sum(bytes) 總字節數,max(bytes),count(*) from dba_free_space group by tablespace_name; 
  數據字典: 
    select table_name from dict order by table_name; 
  鎖及資源信息: 
    select * from v$lock;不包括DDL鎖 
  數據庫字符集: 
    select name,value$ from props$ where name='NLS_CHARACTERSET'; 
  inin.ora參數: 
    select name,value from v$parameter order by name; 
  SQL共享池: 
    select sql_text from v$sqlarea; 
  數據庫: 
    select * from v$database 
  控制文件: 
    select * from V$controlfile; 
  重做日志文件信息: 
    select * from V$logfile; 
  來自控制文件中的日志文件信息: 
    select * from V$log; 
  來自控制文件中的數據文件信息: 
    select * from V$datafile; 
  NLS參數當前值: 
    select * from V$nls_parameters; 
  ORACLE版本信息: 
    select * from v$version; 
  描述后臺進程: 
    select * from v$bgprocess; 
  查看版本信息: 
    select * from prodUCt_component_version;