Skip to main content

Search

Welcome to Tibero GTS!

Phenomenon of tablespace usage showing 100%

Document Type | Troubleshooting 

Field | Monitoring/Inspection

Applicable Product Versions | 6FS07, 6FS07PS, 7FS02, 7FS02PS

Error Code | 21004 

Document Number | TMOTS001

 

Issue

This explains the phenomenon where tablespace usage is displayed as 100% in monitoring tools such as Tibero Studio. 
 

Cause

When all currently allocated file size is used, and autoextend is on with available space up to the max size, Used_Percent appears as 100%.
If the autoextend feature is enabled, EXTENTs are allocated after reaching a certain size for operation.
 

Solutions

1. Check for tablespace shortage errors in syslog

If error 21004 occurs, it is necessary to secure free space for the tablespace by adding datafiles or setting datafile autoextend on.
THROW. ec=ERROR_TX_CANT_ALLOC_EXT(-21004) [ No more extent available in tablespace 'tablespace name'.]
 

2. Check datafile autoextend on/off status

 SQL> SELECT FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE FROM DBA_DATAFILES;
  • If autoextend is on and there is available space up to the max size, no additional action is needed. 
    However, when autoextend is on, it should be configured appropriately to prevent frequent file extensions according to the environment.
  • If autoextend is off, enable it or add datafiles according to the available disk capacity.
Note
You can add datafiles using the following method.
#. Add datafile
SQL> ALTER TABLESPACE [tablespace name] ADD DATAFILE '[datafile path]' SIZE [SIZE] M|G AUTOEXTEND OFF;

ex) ALTER TABLESPACE TS_TEST add DATAFILE '/tbdata/system02/data02.dtf' SIZE 30G AUTOEXTEND OFF;
 
 
 

Related to