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

From: Luch <DarthLuch_at_gmail.com>
Date: Tue, 24 Jul 2007 20:33:48 -0000
Message-ID: <1185309228.769490.54730@d55g2000hsg.googlegroups.com>

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? Received on Tue Jul 24 2007 - 15:33:48 CDT