| Re: Auditing SQL text [message #369608] |
Thu, 02 November 2000 15:49 |
Andrew
Messages: 144
Registered: March 1999
|
Senior Member |
|
|
Using a tool like TOAD you can directly browse the SGA to see the statement, else you can create a trace file and run that through "tkprof" to see the results. See sessions.sql and trace.sql at http://www.angelfire.com/biz4/oraclealley/
if it is your session you want to trace, it's easier. Use "alter session set sql_trace=true;" to turn tracing on and "false" to stop. Your trace file should be the most recent one in the "UDUMP" dir. (SELECT value
FROM v$parameter
WHERE name = 'user_dump_dest')
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
