asked on

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

sapnam

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.

Mahmoud Al Jundi

ASKER

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

radja7

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

ASKER CERTIFIED SOLUTION

radja7

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial