Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trace files to include "SQL*Net message from client" data
On Jul 24, 4:33 pm, Luch <DarthL..._at_gmail.com> wrote:
> I'd like help on how to make a Trace file include this content:
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 5 0.14 0.16 0 0
> 0 0
> Execute 5 0.11 0.13 0 722
> 0 0
> Fetch 5 0.01 0.00 2 15
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 15 0.26 0.30 2 737
> 0 0
>
> Misses in library cache during parse: 4
> Misses in library cache during execute: 2
> Optimizer mode: ALL_ROWS
> Parsing user id: 32
>
> Elapsed times include waiting on following events:
> Event waited on Times Max. Wait Total
> Waited
> ---------------------------------------- Waited ----------
> ------------
> latch: shared pool 1
> 0.00 0.00
> SQL*Net message to client 5
> 0.00 0.00
> SQL*Net message from client 5 39.07
> 154.53
> db file sequential read 2
> 0.00 0.00
> ********************************************************************************
>
> My Trace file only shows this:
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 1 0.00 0.03 0 0
> 0 0
> Execute 1 0.00 0.00 0 0
> 0 0
> Fetch 1 0.00 0.01 2 2
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 3 0.00 0.05 2 2
> 0 0
>
> Misses in library cache during parse: 1
> Optimizer mode: ALL_ROWS
> Parsing user id: 66
>
> Rows Row Source Operation
> ------- ---------------------------------------------------
> 0 COUNT STOPKEY (cr=2 pr=2 pw=0 time=14404 us)
> 0 INDEX RANGE SCAN I_NOTE_PAD_MESSAGE_USER (cr=2 pr=2 pw=0
> time=14391 us)(object id 60141)
>
> I want mine to include the portion that shows the content of
> SQL*Net message from client 5 39.07
> 154.53
>
> . How do I make it do that?
What is the full version of Oracle each of the posted traces came
from?
What is the setting of your statistics level?
What options were used on the tkprof?
HTH -- Mark D Powell -- Received on Wed Jul 25 2007 - 18:59:55 CDT