Creare uno script a crontab di cancellazione dei file di audit più vecchi di x gg sull'istanza DEEPS # su - oracle # crontab -l 01 01 * * * /u01/app/oracle/work/delete_audit.sh 1>/dev/null 2>&1 Individuare la direcotry di audit # show parameter audit_ #  chmod 755 delete_audit.sh # cat delete_audit.sh #!/bin/bash -x export retention=60 export DEEPS=/u01/app/oracle/admin/DEEPS/adump  find $DEEPS  -name "DEEPS*.aud" -type f -ctime +$retention -exec rm {} \; exit

  select s.inst_id,       s.sid,       s.serial#,       s.sql_id,       s.USERNAME,       substr(sqls.sql_text,0,50) as sql_text,       s.service_name,       s.status,       s.seconds_in_wait,       s.WAIT_TIME,       s.last_call_et,       s.machine,       s.program,       s.event,       s.blocking_session,       s.final_blocking_session,       s.blocking_session_status,       s.FINAL_BLOCKING_SESSION_STATUS     --sqls.plan_hash_value       from gv$session s, gv$sqlarea sqls where 1=1 and s.status='ACTIVE' --and s.username <> 'SYS' and s.username <> 'HR' and username not in (select username from dba_users where ORACLE_MAINTAINED='Y') and s.sql_id=sqls.sql_id and S.SQL_ADDRESS = SQLS.ADDRESS   and S.SQL_HASH_VALUE = SQLS.HASH_VALUE  -- and s.sid=46468 order by last_call_et desc;