本文介绍如何在Oracle数据库中配置审计跟踪，并将AUD$表空间从SYSTEM表空间迁移到专门的SYSAUDIT_D表空间中，以提高审计日志管理效率。
alter system set audit_trail=DB_EXTENDED scope=spfile;
SQL>audit select,insert,update,delete on mydb.yyp by access whenever successful;
From:
Oracle Security - For auditing, move the aud$ to another tablespace
If you are performing any kind of auditing on the database, we recommend that you move the aud$ tablespace from the system tablespace to another tablespace. In this example, we are moving the aud$ tablespace to a tablespace called SYSAUDIT_D.
If you are on ASM, you would change the file location to an ASM diskgroup such as ‘+data’.
- def DB='&1'
- def FS='&2'
- CREATE TABLESPACE SYSAUDIT_D DATAFILE
- '/data/oracle/&DB/&FS/sysaudit_d_01.dbf' SIZE 200m AUTOEXTEND OFF
- LOGGING ONLINE PERMANENT
- EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
- create table audx tablespace SYSAUDIT_D as select * from aud$ where 1 = 2;
- rename AUD$ to AUD$$;
- rename audx to aud$;
- drop index i_aud1;
- create index i_aud1 on aud$(sessionid, ses$tid) tablespace SYSAUDIT_D;
- set echo off
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/230160/viewspace-621213/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/230160/viewspace-621213/
扫一扫
1948
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
