2014-08-09-1.sql

botang

1. select * from dba_views v where v.view_name='DBA_ALERT_HISTORY';
   
2. 
   
3. select  * from dba_views v where v.view_name='DBA_OUTSTANDING_ALERTS';
   
4. 
   
5. ---wri$_   ---wrh$_  --wrm$  --wrr
   
6. 
   
7. 
   
8. select * from dba_tables t where t.table_name like 'WRA%';
   
9. 
   
10. 
    
11. select * from v$active_session_history;
    
12. 
    
13. select  * from DBA_HIST_ACTIVE_SESS_HISTORY;
    
14. 
    
15. select  * from dict where table_name like 'DBA%ACTIVE%';
    

复制代码