（52-29）第48次：2016-02-23星期二

botang

(52-29)上完1Z0-052的第10章

2016-02-23.sql:

1. select * from dba_rollback_segs;
   
2. 
   
3. select  * from v$undostat;
   
4. 
   
5. select  * from dba_tablespaces;
   
6. 
   
7. alter tablespace undotbs1 retention noguarantee;
   
8. 
   
9. select * from v$fixed_table  where name like 'V%ADVICE%';
   
10. 
    
11. ----
    
12. create undo tablespace undotbs2 datafile size 256K autoextend off;
    
13. 
    
14. create temporary  tablespace temp2 tempfile '/home/oracle/temp2.dbf' size 15G;
    
15. 
    
16. drop tablespace undotbs1;
    
17. 
    
18. ---
    
19. select * from dba_rollback_segs;
    
20. 
    
21. 
    
22. alter database default temporary tablespace temp2;
    
23. 
    
24. drop tablespace temp;
    
25. ---
    
26. 
    
27. 
    
28. select  * from dba_alert_history ;
    
29. 
    
30. select  * from v$sql where sql_id = 'b4ypsk068tpkv';
    
31. 
    
32. 
    

复制代码

1. select * from v$transaction;
   
2. 
   
3. --00000001EAE82800
   
4. 
   
5. select * from flashback_transaction_query where logon_user = 'HR'
   
6.   and table_name='EMPLOYEES';
   
7. ---
   
8. 
   
9. 
   
10. 
    
11. 
    
12. create undo tablespace undotbs2 datafile size 20M  autoextend on;
    
13. 
    
14. alter system set undo_tablespace=undotbs2;
    
15. 
    
16. drop tablespace undotbs1;
    
17. 
    
18. alter system flush buffer_cache;
    
19. 
    
20. 
    
21. alter database add supplemental log data;
    
22. 
    
23. select  
    
24.    d.SUPPLEMENTAL_LOG_DATA_MIN,
    
25.    d.SUPPLEMENTAL_LOG_DATA_PK,
    
26.    d.SUPPLEMENTAL_LOG_DATA_UI,
    
27.    d.SUPPLEMENTAL_LOG_DATA_FK,
    
28.    d.SUPPLEMENTAL_LOG_DATA_ALL
    
29.    
    
30.    from v_$database d;
    
31.    
    
32.    ----
    
33.    select * from flashback_transaction_query where logon_user = 'HR'
    
34.   and table_name='EMPLOYEES';
    
35.    
    
36. ----
    
37. 
    
38. 
    
39. 
    

复制代码