Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trace files to include "SQL*Net message from client" data

Re: Trace files to include "SQL*Net message from client" data

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 25 Jul 2007 16:59:55 -0700
Message-ID: <1185407995.924877.65790@z24g2000prh.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US