• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1518
  • Last Modified:

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
0
m_jundi
Asked:
m_jundi
  • 2
1 Solution
 
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.
0
 
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
0
 
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

0
 
radja7Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now