oracle数据库sysaux表空间,如何管理oracle数据库的SYSAUX表空间

关闭不必要的审计,aud$.

移动到别的表空间,一些审计登录审计可以关闭,我个人建立登录审计,仅仅审计不成功的登录.

我以前笔记:

NOAUDIT CREATE SESSION WHENEVER SUCCESSFUL;

--//移动审计到另外的表空间.txt

CREATE TABLESPACE TSP_AUDIT DATAFILE

'+DATA/fyhis/datafile/tsp_audit01.dbf' SIZE 740M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

LOGGING

ONLINE

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

BLOCKSIZE 8K

SEGMENT SPACE MANAGEMENT AUTO

FLASHBACK ON;

> SELECT table_name, tablespace_name FROM   dba_tables WHERE  table_name IN ('AUD$', 'FGA_LOG$') ORDER BY table_name;

TABLE_NAME TABLESPACE_NAME

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

AUD$       SYSTEM

FGA_LOG$   SYSTEM

--以sys用户执行:

BEGIN

DBMS_AUDIT_MGMT.set_audit_trail_location(

audit_trail_type           => DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD,

audit_trail_location_value => 'TSP_AUDIT');

END;

/

ALTER USER SYS QUOTA UNLIMITED ON TSP_AUDIT;

--说明:

The AUDIT_TRAIL_TYPE parameter is specified using one of three constants.

DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD: Standard audit trail (AUD$).

DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD: Fine-grained audit trail (FGA_LOG$).

DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD: Both standard and fine-grained audit trails.

----------

> SELECT table_name, tablespace_name FROM   dba_tables WHERE  table_name IN ('AUD$', 'FGA_LOG$') ORDER BY table_name;

TABLE_NAME TABLESPACE_NAME

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

AUD$       TSP_AUDIT

FGA_LOG$   TSP_AUDIT