Database Spylog for veiwing DB calls

bscyadav · #1 (**permalink**) January 6th, 2010, 10:12

Hi,
Is there any spylog available to veiw the DB calls for OTM
My system Config
O/S : Windows 2003 64 bit
App server: OAS

I have tried using P6SpyLog by changing the data-sources.xml but it is replaced when ever i restart the Application and neither it is getting recorded.

Regards
bscyadav

stoganv · #2 (**permalink**) January 10th, 2010, 23:14

OTM has a sql logging function. Not sure how to turn it on but you can set it up so that it logs all of it's db calls.

Alternatively you could ask your DBA top set up sql trace and go through the trace files to work out what's going on.

chrisplough · #3 (**permalink**) January 25th, 2010, 01:57

Just keep in mind that the SQL logging is VERY performance intensive, so only enable it in non-PROD environments -- or only for a limited time in PROD.

--Chris