You could use a DDL trigger to capture this.
mvg/regards
Jo
Hemant K Chitale
<hkchital@singnet
.com.sg> To
Sent by: ORACLE-L@xxxxxxxxxxxxx
oracle-l-bounce@f cc
reelists.org
Subject
Auditing ALTER DATABASE and ALTER
17-03-06 16:40 SYSTEM commands
Please respond to
hkchital@singnet.
com.sg
Apparently, the "ALTER DATABASE" command
(eg ALTER DATABASE DATAFILE <filename> RESIZE) cannot be audited.
Although the "ALTER SYSTEM" can be audited, I cannot find from
DBA_AUDIT_OBJECT
or DBA_AUDIT_STATEMENT which ALTER SYSTEM command
(ALTER SYSTEM CHECKPOINT, ALTER SYSTEM SWITCH LOGFILE, ALTER SYSTEM SET
SORT_AREA_SIZE=)
was issued.
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
