Home » SQL & PL/SQL » Client Tools » Capture OCI sql HELP
Capture OCI sql HELP [message #295567] Tue, 22 January 2008 15:12 Go to next message
Messages: 135
Registered: April 2005
Location: Canada
Senior Member

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
Re: Capture OCI sql HELP [message #295572 is a reply to message #295567] Tue, 22 January 2008 15:25 Go to previous message
Michel Cadot
Messages: 67840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Activate trace. See http://www.orafaq.com/forum/mv/msg/96055/295538/102589/#msg_295538
- Use LogMiner


[Updated on: Tue, 22 January 2008 15:26]

Report message to a moderator

Previous Topic: Unable to connect
Next Topic: Spooling file in Unicode format
Goto Forum:

Current Time: Fri May 07 10:44:24 CDT 2021