Re: Tracing a single SQL statement

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 1 Mar 2010 18:24:23 -0800 (PST)
Message-ID: <45361.44988.qm_at_web113211.mail.gq1.yahoo.com>

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

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_at_gmail.com>
To: Oracle-L Freelists <oracle-l_at_freelists.org> 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
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 01 2010 - 20:24:23 CST

This message: [ Message body ]
Next message: Greg Rahn: "Re: Performance issue after creating higher block size tablespace - a further question"
Previous message: Rich: "Tracing a single SQL statement"
In reply to: Rich: "Tracing a single SQL statement"
Next in thread: Dion Cho: "Re: Tracing a single SQL statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message