| Capture OCI sql HELP [message #295567] |
Tue, 22 January 2008 15:12  |
evoradba
Messages: 144
Registered: April 2005
Location: Canada
|
Senior Member |
|
|
Hello
I need to capture what is the SQL that is going through OCI call through the database, when the application starts it opens about 400 connections and one of them is updating, deleting a table which I need to see the sql.
Is there an away of capturing the SQL? This is oracle 10.2 on Solaris 5.8, I tried staspack unfortunately does not show anything even through the OEM does not show which spid is inserting
Any help would be great
Thank you
maria
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
