1. alert file stored in
background_dump_dest
you need to truncate it manually when it grows oversize .
basically , if something bad seriously happen in DB , this is the file you need to check .2.
The database initialization parameter AUDIT_TRAIL controls the enabling and disabling of auditing. The default setting for this parameter is NONE, which means that no auditing will be performed, regardless of whether or not AUDIT commands are issued. It is important to remember that any auditing statements issued will not be performed if AUDIT_TRAIL=NONE. Unless auditing is enabled in the database parameter initialization file, any auditing options that have been turned on will not create records in the audit trail. Auditing is not completely disabled unless it is set to NONE in the database parameter initialization file.You must set the database initialization parameter AUDIT_TRAIL to DB or OS to enable auditing. The DB setting means the audit trail records are stored in the database in the SYS.AUD$ table. OS will send the audit trail records to an operating system file. The OS setting is operating system-dependent and is not supported on all operating systems. Example:AUDIT DELETE TABLE, INSERT TABLE,
EXECUTE ANY PROCEDURE
BY beth
BY ACCESS
WHENEVER SUCCESSFUL;
background_dump_dest
you need to truncate it manually when it grows oversize .
basically , if something bad seriously happen in DB , this is the file you need to check .2.
The database initialization parameter AUDIT_TRAIL controls the enabling and disabling of auditing. The default setting for this parameter is NONE, which means that no auditing will be performed, regardless of whether or not AUDIT commands are issued. It is important to remember that any auditing statements issued will not be performed if AUDIT_TRAIL=NONE. Unless auditing is enabled in the database parameter initialization file, any auditing options that have been turned on will not create records in the audit trail. Auditing is not completely disabled unless it is set to NONE in the database parameter initialization file.You must set the database initialization parameter AUDIT_TRAIL to DB or OS to enable auditing. The DB setting means the audit trail records are stored in the database in the SYS.AUD$ table. OS will send the audit trail records to an operating system file. The OS setting is operating system-dependent and is not supported on all operating systems. Example:AUDIT DELETE TABLE, INSERT TABLE,
EXECUTE ANY PROCEDURE
BY beth
BY ACCESS
WHENEVER SUCCESSFUL;
再次讨教: 我把电脑日期该为2008年,然后执行一个SELECT操作,之后在OS下查询哪些文件的日期是2008年, 发现ORACLE目录下没有 ? 难道ORACEL写文件不通过OS, 另外是哪个文件? 或哪个VIEW ?
select * from dba_data_files