We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now


Audit Trail on Oracle 8i 8.1.7

m_jundi asked
Medium Priority
Last Modified: 2012-08-13
Dear All,

I have activated Oracle trail using the following steps :
1) Connect as Sys
2) Execute Catalog.sql Procedure
3) Execute CATAUDIT.SQL Procedure
4) Issue the command : Audit All; in order to Audit all DB activities

I have Executed many SQL statements but can't find any records in SYS.AUD$ view !!!

Are there any missing actions should be taken in order to make audit trail work

Thanks in advance
Watch Question

I believe you have to add the audit_trail parameter in your init.ora file.

Try the following:


which will start logging in the SYS.aud$ table.

Another valid value is also audit_trail=os  

which will start logging in the operating system audit file, may not be what you want.


Many Thanks Sapnam for your reply, but the correct value is audit_trail=true

Now My DB start logging but I thought audit trial will give more clear data, What I need exactly what SQL & Stored procedures the users execute, I want to trace an action for a program in the DB , means which stored procedures run when this program executed. the program built in Powerbuilder and we don't have the source code.


You do not need audit for this purposes.
Join this with V$SESSION (SQL_HASH_VALUE, SQL_ADDRESS) to monitor current sql activity by sessions

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.