Changing AUDIT_FILE_DEST dynamically.
I'm looking for a solution to dynamically change OS audit trail location while oracle db instance is still alive.
With 10.2, it is suggested as AUDIT_FILE_DEST as ALTER SYSTEM SET AUDIT_FILE_DEST <dir> DEFERRED.
What happens to the sessions, than?
- The new ones pick on the new destination;
- The old ones stick to the former destination. May that OS file be truncated? Or, Oracle would have a problem?
- If I discover that all sessions are newer than the ALTER above, may I truncate the former audit file?
- What would be suggested to collect session information - mostly it's start time and idle status?
What happens to the sessions, than?
- The new ones pick on the new destination;
- The old ones stick to the former destination. May that OS file be truncated? Or, Oracle would have a problem?
- If I discover that all sessions are newer than the ALTER above, may I truncate the former audit file?
- What would be suggested to collect session information - mostly it's start time and idle status?
0