Audit Trail on Oracle 8i 8.1.7

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
m_jundiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Try the following:

audit_trail=db

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.
m_jundiAuthor Commented:
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.

Thanks
MAHMOUD
radja7Commented:
You do not need audit for this purposes.
Use V$SQLTEXT, V$SQL, V$OPEN_CURSOR
Join this with V$SESSION (SQL_HASH_VALUE, SQL_ADDRESS) to monitor current sql activity by sessions

radja7Commented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.