课程第15/16/17次（2017-03-27星期一，2017-03-29星期三和2017-03-31星期五）

botang · 发表于 2017-3-28 10:37:09

本帖最后由 botang 于 2017-4-1 10:49 编辑

上完1Z0-052第10章：UNDO
上完1Z0-052的Chapter0和1Z0-053的Chapter0
进行1Z0-052第1章
1Z0-051共12章（上完10章），1Z0-052共19章（上完6章），1Z0-053共21章（上完1章）
总共上完全部52章中的17章

select * from dba_tablespaces ;
alter tablespace undotbs1 retention guarantee;
alter tablespace undotbs1 retention noguarantee;
-------
select * from dba_temp_files;
alter tablespace temp add tempfile '/u01/app/oracle/oradata/orcl/temp02.dbf' size 10G;
alter tablespace temp drop tempfile 1;
create undo tablespace undotbs2 datafile size 256k autoextend off ;
------
select * from dba_rollback_segs;
select * from dba_alert_history order by creation_time desc ;
-----
select * from dba_data_files where tablespace_name='UNDOTBS2';
alter database datafile '+DATA/orcl/datafile/undotbs2.264.939759457' resize 10M;
----
select salary from hr.employees
as of timestamp to_timestamp('2017-03-27:20:40:06','YYYY-MM-DD:HH24:MI:SS')
where employee_id=100;
---
create undo tablespace undotbs1 ;
alter system set undo_tablespace=undotbs1;
drop tablespace undotbs2;
select * from v$transaction;
alter system flush buffer_cache;
select salary from hr.employees
as of timestamp to_timestamp('2017-03-27:20:40:06','YYYY-MM-DD:HH24:MI:SS')
where employee_id=100;

复制代码

select d.RESETLOGS_CHANGE#,
d.CHECKPOINT_CHANGE# ,
d.CURRENT_SCN from v_$database d;
select df.NAaME, df.CHECKPOINT_CHANGE# from v_$datafile df;
select * from v$thread;
alter tablespace users online;
select * from v$log;
select * from v$archived_log order by 5 desc , 6 desc;
-----
alter system switch logfile;
alter system checkpoint;
----
----
alter tablespace users offline;
alter system checkpoint;
----
alter tablespace example read only;
alter tablespace example read write;
----

复制代码