Usage of the tablespace system and sysaux in the Oracle system

The following articles mainly describe the usage of the Oracle system tablespace system and sysaux. In fact, the usage of the Oracle system tablespace system and sysaux is very high in actual operations, when I was idle today, I saw my Oracle Database's Oracle system tablespace system. The usage of sysaux is very high. See the following:

The table space usage on the server is as follows:

Tablespace name tablespace size (M) used space (M) Use the largest partition than the idle space (M)

 
 

  
  
LMS_TABLESPACE 32 .44 1.38 31.56 30.81  
  
  
SYSAUX 310 309.25 99.76 .75 .75  
  
  
SYSTEM 450 440.69 97.93 9.31 8.94  
  
  
UNDOTBS1 25 11.75 47.00 13.25 11.94  
  
  
USERS 5 .44 8.80 4.56 4.56  
 
 

The solution is as follows:

1. Check whether the system and sysaux tablespaces are automatically extended.

 
 

  
  
SQL>select tablespace_name,AUTOEXTENSIBLE,INCREMENT_BY from dba_data_files; 
 
 

The AUTOEXTENSIBLE field value should be

YES, whether it is NO; INCREMENT_BY is the size of the automatically expanded space each time.

2. If your system tablespace is not automatically extended, you can use the following methods to expand it.

A. add data files in the system tablespace.

 
 

  
  
SQL>alter tablespace system add datafile 'D:\OracleXE\oradata\XE\system_01.dbf' resize 1024M; 
 
 

B. Modify the data file of the system so that it can be automatically expanded and expanded.

 
 

  
  
SQL>alter database datafile 'D:\OracleXE\oradata\XE\system_01.dbf' autoextend on;  
  
  
SQL>alter database datafile 'D:\OracleXE\oradata\XE\system_01.dbf' resize 2048M;   
 
 

The above content describes the usage of the tablespace system and sysaux in the Oracle system. We hope it will help you in this regard.