DBMS_AUDIT_MGMT 审计跟踪类型 常量数据类型说明 AUDIT_TRAIL_ALLPLS_INTEGER所有审计跟踪类型。这包括标准数据库审计跟踪和操作系统 (OS) 审计跟踪。 AUDIT_TRAIL_AUD_STDPLS_INTEGER标准审计。 AUDIT_TRAIL_DB_STDPLS_INTEGER标准审计。 AUDIT_TRAIL_FILESPLS_INTEGER操作系统 (OS) 审计跟踪。
DBA_AUDIT_MGMT_CLEANUP_JOBS 現在構成されている監査証跡パージ・ジョブを表示します。 DBA_AUDIT_MGMT_CONFIG_PARAMS 現在構成されている監査証跡プロパティを表示します。 DBA_AUDIT_MGMT_LAST_ARCH_TS 監査証跡の最終アーカイブ・タイムスタンプ設定を表示します。 関連項目: これらの...
The DBMS_AUDIT_MGMT package provides subprograms to manage audit trail records. These subprograms enable audit administrators to manage the audit trail. In a mixed-mode environment, these audit trails comprise the database, operating system (OS), and XML
The DBMS_AUDIT_MGMT subprograms enable you to perform cleanup operations on all audit trail types. Audit trail records can be deleted based on their last archive timestamp. The last archive timestamp indicates when the audit records were last archived. 关于该包的使用我就不科普了,到这里dbms_audi...
dbms_audit_mgmt.audit_trail_unified, use_last_arch_timestamp => FALSE);end;/ begin * ERROR ...
DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_PROPERTY( audit_trail_type => AUDIT_TRAIL_FILES, audit_trail_property => OS_FILE_MAX_SIZE, audit_trail_property_value => 512000); Auch diese Prozedur kann über die entsprechenden Parameter differenziert mit den Oracle proprietären Dateien und den Dateien...
DBMS_AUDIT_MGMT.INIT_CLEANUP( audit_trail_type => dbms_audit_mgmt.AUDIT_TRAIL_OS, default_cleanup_interval => 24*7); -->The default time interval, in hours, after which the cleanup procedure should be called. end; / 2. set last archive timestamp –> This procedure sets a timestamp ...
When DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION is used to change the default tablespace used for ...
Audit cleanup fails with following errors.BEGIN*ERROR at line 1:ORA-20005: object statistics are locked (stattype = ALL) <<<ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 2544ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 4949ORA-06512: at "SYS.DBMS_STATS", line 36873ORA-06512: at "SYS.D...
Applies to: Symptoms Unified Auditing purge took almost 3 days to purge 10GB audit log by DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL using last_arch_timestamp. The awrinfo report shows that the old partition of AUDSYS.AUD$UNIFIED is larger than 10GB. ...