exec dbms_audit_mgmt.clean_audit_trail(audit_trail_type=>dbms_audit_mgmt.audit_trail_unified,
use_last_arch_timestamp=>FALSE);
-
debasis maity in SCRIPTS
Script to clean or truncate unified audit record table
Leave a Comment
Related Post
-
Script for checking tablespace growth
with t as ( select ss.run_time,ts.name,round(su.tablespace_size*dt.block_size/1024/1024/1024,2) alloc_size_gb, round(su.tablespace_usedsize*dt.block_size/1024/1024/1024,2) used_size_gb from dba_hist_tbspc_space_usage su, (select trunc(BEGIN_INTERVAL_TIME) run_time,max(snap_id)…
-
script to get query for reclaim space from auto extensible datafile
set linesize 1000 pagesize 0 feedback off trimspool on with hwm as ( -- get…