设为首页收藏本站

Botang唐波's Oracle Station

查看: 1055|回复: 0

(52-29)第48次:2016-02-23星期二

[复制链接]

745

主题

1118

帖子

8120

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8120
发表于 2016-2-24 09:37:15 | 显示全部楼层 |阅读模式
(52-29)上完1Z0-052的第10章

2016-02-23.sql:
  1. select * from dba_rollback_segs;

  2. select  * from v$undostat;

  3. select  * from dba_tablespaces;

  4. alter tablespace undotbs1 retention noguarantee;

  5. select * from v$fixed_table  where name like 'V%ADVICE%';

  6. ----
  7. create undo tablespace undotbs2 datafile size 256K autoextend off;

  8. create temporary  tablespace temp2 tempfile '/home/oracle/temp2.dbf' size 15G;

  9. drop tablespace undotbs1;

  10. ---
  11. select * from dba_rollback_segs;


  12. alter database default temporary tablespace temp2;

  13. drop tablespace temp;
  14. ---


  15. select  * from dba_alert_history ;

  16. select  * from v$sql where sql_id = 'b4ypsk068tpkv';


复制代码
  1. select * from v$transaction;

  2. --00000001EAE82800

  3. select * from flashback_transaction_query where logon_user = 'HR'
  4.   and table_name='EMPLOYEES';
  5. ---




  6. create undo tablespace undotbs2 datafile size 20M  autoextend on;

  7. alter system set undo_tablespace=undotbs2;

  8. drop tablespace undotbs1;

  9. alter system flush buffer_cache;


  10. alter database add supplemental log data;

  11. select  
  12.    d.SUPPLEMENTAL_LOG_DATA_MIN,
  13.    d.SUPPLEMENTAL_LOG_DATA_PK,
  14.    d.SUPPLEMENTAL_LOG_DATA_UI,
  15.    d.SUPPLEMENTAL_LOG_DATA_FK,
  16.    d.SUPPLEMENTAL_LOG_DATA_ALL
  17.    
  18.    from v_$database d;
  19.    
  20.    ----
  21.    select * from flashback_transaction_query where logon_user = 'HR'
  22.   and table_name='EMPLOYEES';
  23.    
  24. ----



复制代码



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-12-13 12:14 , Processed in 0.156681 second(s), 24 queries .

快速回复 返回顶部 返回列表