-
SQL from The TRACEFILE
OS: IBM AIX5.1
DB: Oracle 9i R2
I just started the Databaes trace with following steps:
--
Modify the "init.ora" file,stop/start the instance to make the parameter effective.
SQL> connect internal
SQL> @$ORACLE_HOME/admin/cataudit.sql
SQL> shutdown immediate
SQL> startup
SQL> audit select any table;
SQL> audit drop any table;
SQL> audit......
many more..
Now how can I see the SQL Statements Users are submitting against the tables.
Thanks for all the replies.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|