课程第18次

botang

1. select * from dba_tablespaces;
   
2. 
   
3. select * from dba_rollback_segs;
   
4. 
   
5. select * from v$transaction;
   
6. 
   
7. select   f.tablespace_name,
   
8.          f.autoextensible,
   
9.          f.maxbytes
   
10. from dba_data_files  f where tablespace_name='UNDOTBS1';

复制代码

	TABLESPACE_NAME	AUTOEXTENSIBLE	MAXBYTES
1	UNDOTBS1	YES	34359721984

1. alter database datafile '+DATA/orcl/datafile/undotbs1.263.1011147947'
   
2. autoextend on maxsize 4G;
   
3. 
   
4. select   f.file_name,
   
5.          f.tablespace_name,
   
6.          f.autoextensible,
   
7.          f.maxbytes
   
8. from dba_data_files  f where tablespace_name='UNDOTBS1';

复制代码

	FILE_NAME	TABLESPACE_NAME	AUTOEXTENSIBLE	MAXBYTES
1	+DATA/orcl/datafile/undotbs1.263.1011147947	UNDOTBS1	YES	4294967296