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.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.