Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Auditing ALTER DATABASE and ALTER SYSTEM commands
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 17 2006 - 09:40:37 CST
![]() |
![]() |