Re: Tracing a single SQL statement

  • From: Robert Freeman <robertgfreeman@xxxxxxxxx>
  • To: richa03@xxxxxxxxx, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 1 Mar 2010 18:24:23 -0800 (PST)

See http://www.oracle-base.com/articles/10g/SQLTrace10046TrcsessAndTkprof10g.php

RF


 Robert G. Freeman
Master Principle Consultant, Oracle Corporation
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide 
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com




________________________________
From: Rich <richa03@xxxxxxxxx>
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Sent: Mon, March 1, 2010 6:15:45 PM
Subject: Tracing a single SQL statement

Hi all,

This is 64-bit 10.2.0.4 on RHEL 5.1 (kernel 2.6.18-53).

Is there any way to set 10046 and/or 10053 tracing on for a single SQL
statement in another session without access to the SQL code?

Thanks,
Rich
--
//www.freelists.org/webpage/oracle-l

Other related posts: