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.
NoteYou 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;