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

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?

.

Relevant Pages

  • Parallel queries slow
    ... as if in order to do the parallel query Oracle needs to execute round ... call count cpu elapsed disk query current ... Misses in library cache during execute: ...
    (comp.databases.oracle.server)
  • A myth of TKPROF output in Oracle 10.1.0.4
    ... Why some SQL statements did not have a "wait event" section. ... call count cpu elapsed disk query current ... Misses in library cache during parse: ...
    (comp.databases.oracle.server)
  • Slow SQL, too many logical reads ?
    ... call count cpu elapsed disk query ... Misses in library cache during parse: ...
    (comp.databases.oracle.server)
  • Re: Slow response of forms
    ... I can see delay in one more section of trf file: ... call count cpu elapsed disk query current ... Misses in library cache during parse: ...
    (comp.databases.oracle.server)
  • Re: ORACLE PAGING PERFORMANCE
    ... call count cpu elapsed disk query current ... Elapsed times include waiting on following events: ... Parsing user id: SYS ...
    (comp.databases.oracle.server)