Home » Other » Client Tools » Capture OCI sql HELP
- Capture OCI sql HELP [message #295567] Tue, 22 January 2008 15:12 Go to next message
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

Report message to a moderator

- 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: 68758
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 06 06:39:51 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.