表满专题

oracle 审计表满,由于开启审计AUD$表导致system表空间满了~

于是进行详细的查询: 查看system表空间里磁盘占用较大的segment SELECT * FROM (SELECT BYTES, segment_name, segment_type, owner FROM dba_segments WHERE tablespace_name = 'SYSTEM' ORDER BY BYTES DESC) WHERE ROWNUM < 10; select