Oracle 12c sysaux 表空间不足处理-AUDSYS.CLI_SWP$def5007c$1$1

Oracle 12c sysaux 表空间不足处理-AUDSYS.CLI_SWP$def5007c$1$1

告警日志内容：

ORA-1688: unable to extend table AUDSYS.CLI_SWP$def5007c$1$1 partition HIGH_PART by 128 in tablespace SYSAUX [TEST]

从告警信息直接切换到对应的pdb下查看sysaux表空间空间占用情况：sysaux表空间使用率已经100%，分析过程及解决办法如下：

SQL> alter session set container=TEST;

 

Session altered.

 

 

SQL> SELECT occupant_name "Item",

           space_usage_kbytes / 1048576 "Space Used (GB)",

           schema_name "Schema",

           move_procedure "Move Procedure"

  FROM v$sysaux_occupants

 ORDER BY 2 desc;  2    3    4    5    6  

 

Item    Space Used (GB) Schema     Move Procedure

-------------------------------------------------- --------------- ---------------------------------------- --------------------------------------------------

AUDSYS  31.487793 AUDSYS

SDO .075866699 MDSYS     MDSYS.MOVE_SDO

XDB .065368652 XDB     XDB.DBMS_XDB.MOVEXDB_TABLESPACE

SM/OTHER    .046875