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
evoradba
Messages: 104
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
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: 64111
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

Regards
Michel

[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: Mon Dec 05 19:26:51 CST 2016

Total time taken to generate the page: 0.06591 seconds