oracle表空间不足报错排查及扩容

一、报错代码：

Error updating database.  Cause: java.sql.SQLException: ORA-01691: unable to extend lob segment OMSP_FLOWGINE.SYS_LOB0000035445C00014$$ by 1024 in tablespace OMSP

 

二、排查执行下面sql:

SELECT a.tablespace_name,
TRUNC (tablespace_size * b.block_size / 1024 / 1024 )
"TOTAL(MB)",
TRUNC (used_space * b.block_size / 1024 / 1024 ) "USED(MB)",
TRUNC (
(TABLESPACE_SIZE - used_space) * b.block_size / 1024 / 1024 )
"FREE(MB)",
ROUND (USED_PERCENT) "USED_PERCENT(%)"
FROM DBA_TABLESPACE_USAGE_METRICS a, dba_tablespaces b
WHERE a.tablespace_name = b.tablespace_name
ORDER BY USED_PERCENT DESC;

 

 

三、扩容方法

alter tablespace OMSP(对应表空间名称) add datafile size 4096M autoextend on next 100M maxsize 32700M;