|
- select * from v$transaction;
- select * from dba_rollback_segs;
- select * from dba_tablespaces;
- select * from v$tablespace;
复制代码 实验的语句:
- select * from dba_rollback_segs;
- create undo tablespace undotbs2 datafile size 256k autoextend off;
- select * from dba_rollback_segs;
- alter tablespace temp add tempfile '/u01/app/oracle/oradata/orcl/temp02.dbf' size 10G
- autoextend on maxsize 20G;
-
- alter tablespace temp drop tempfile '/u01/app/oracle/oradata/orcl/temp02.dbf' ;
- drop tablespace undotbs2;
复制代码 快照太旧的窗口:
- SQL> @select_t04209_uname.sql
- select a.uname,a.uvalue, b.uname ,b.uvalue from t04209_uname a, t04209_uname b order by a.uname
- *
- ERROR at line 1:
- ORA-01555: snapshot too old: rollback segment number 11 with name
- "_SYSSMU11_3368693052[ DISCUZ_CODE_2 ]quot; too small
复制代码- select * from dba_rollback_segs;
- select * from dict
- where table_name like '%UNDO%' or table_name like '%ROLL%';
-
- select * from v$rollstat;
-
- select * from v$undostat;
-
- select * from dba_hist_undostat;
复制代码- select * from dba_alert_history;
复制代码
|
|