Ask the Expert

Can't see audit logs

We enabled the audit_trail=true from init.ora, restarted the database, then opened audit for select, but we couldn't see any audit logs. What can we do?

    Requires Free Membership to View

If you have AUDIT_TRAIL=TRUE, that is just the first part. You'll need to tell Oracle what to audit. This is done with the AUDIT command.

When Oracle does log items in the audit trail, you will find them in the DBA_AUDIT_TRAIL view. If you want the audit trail written to an external file, then set AUDIT_TRAIL=OS instead.

This was first published in January 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: