oracle undo 学习笔记

1.select * from v$tablespace;

2.select * from dba_tablespaces;

3.select * from DBA_DATA_FILES;

4.select * from DBA_ROLLBACK_SEGS;

5.create undo tablespace UNDOTBS02 datafile 'D:\APP\MAXINE\ORADATA\SMART\UNDOTBS02.DBF' size 10m;

6.select * from dba_segments where tablespace_name='UNDOTBS02';

7.SELECT * FROM V$TRANSACTION;

8.SELECT * FROM V$session where taddr='000007FF62CE5000';

9.show parameter rollback;

10.alter system dump datafile 10 block 312;

11.select distinct sid from v$mystat;

12.select paddr from v$session where sid=258;

13.select * from v$process where addr='000007FF657B0CE0';

14.show parameter user;

15.select * from dba_objects where owner='C' and object_name='T';

16.select * from dba_users;

17.select * from dba_roles where role='SELECT_CATALOG_ROLE' ;

18.select * from v$log;

19.select * from v$rollstat;

20.select * from v$sql where sql_id='6ubd0c60r1tr9';

21.alter database datafile  'D:\APP\MAXINE\ORADATA\SMART\UNDOTBS02.DBF' resize 45m;

22.select * from v$sql where sql_text like 'select * from t where id=%';

23.alter user d account unlock;

24.show parameter db_recovery_file_dest_size;

25.select *from v$flash_recovery_area_usage;

26.select * from v$undostat;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29622945/viewspace-1370117/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29622945/viewspace-1370117/