| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: sql_Trace and tkprof
A copy of this was sent to Umar FArooq <umar.farooq_at_cressoft.com.pk>
(if that email address didn't require changing)
On Mon, 22 Jun 1998 18:21:32 +0500, you wrote:
>Thomas Kyte wrote:
>
>> platform?
>> version?
>> how are you doing the tracing...
Ok, how are you doing the tracing? What are the steps to reproduce your situation?
>> etc, etc, etc?
>
>Oracle 7.3.2 on UNIX
Any unix in particular? Looking for port specific issues here.
>
>> If you are doing something like:
>>
>> SQL> alter session set sql_trace=true;
>> SQL> select count(*) from emp;
>> SQL> alter session set sql_trace=false;
>>
>
>I dont set sql_trace to false
>
>> You'll get rowcounts of zero (using sql_trace=false) since the row
>> counts are
>> not written to the trace file until the cursor is CLOSED and sqlplus
>> doesn't
>> close the cursors right away. By doing the sql_trace=false, you've
>> closed the
>> trace file before the cursor data was traced.
>>
>> >
>
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jun 22 1998 - 08:54:21 CDT
 |
 |