第37-38次：2015-04-18星期六上下午

botang

1. select  * from v$flashback_database_log;
   
2. 
   
3. --4/18/2015 9:54:02 AM
   
4. 
   
5. --1052450
   
6. 
   
7. select  * from v$flashback_database_stat;
   
8. 
   
9. select  * from v$flashback_database_logfile;
   
10. 
    
11. select * from v$fixed_table  where name like '%USAGE%';
    
12. 
    
13. select  * from V$RECOVERY_AREA_USAGE;
    
14. 
    
15. select  * from v$restore_point;
    

复制代码

1. select  * from dba_recyclebin;
   
2. 
   
3. select * from dba_segments s where s.segment_name like '%T05311_BIN2';
   
4. 
   
5. select  * from dba_recyclebin;
   
6. 
   
7. 
   
8. select  * from dba_indexes i where i.owner='HR' and i.table_name='T05311_BIN2';
   
9. 
   
10. alter index  hr."BIN$E9e/ZQ8+DLvgUKjAWgBxZQ==$0" rename to pk_T05311_BIN2;
    
11. 
    
12. select    sum(bytes)/1024/1024    from dba_data_files where tablespace_name='USERS';
    
13. 
    
14. select  sum(bytes)/1024/1024   from dba_free_space where tablespace_name='USERS';
    
15. 
    
16. purge tablespace users  user hr;
    
17. 
    
18. purge tablespace users;
    

复制代码