-
Hi everyone,
Trying to find out how I can tell who and when a particular sql statement was issued. I realize 8i has the log miner. But I am running 8.0.5, how to accomplish this before 8i log miner?
Thanks in advance,
Kathy
-
You might be able to find it in V$SQL
-
-
both are right. Auditing will add perfomance overhead, check out in V$SQL DPT
A Winner never Quits, A Quitter never Wins
Ganesh .R
-
Does V$SQL contain the full SQL text? cause the text field is only vc2(1000);
There Nothing You cannot Do, The problem is HOW.
-
is so then check out v$sqltext table
A Winner never Quits, A Quitter never Wins
Ganesh .R
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
|