Why the query buffers are more than row size?

From: KG <kkethine_at_cisco.com>
Date: Thu, 23 Jul 1998 14:59:37 -0700
Message-ID: <35B7B249.9E944B20@cisco.com>

All my SQL scripts, when monitored using SQL_TRACE, are querying huge amount of buffers than the actual rows fetched.

Why is it happening? There are no FULL scans.

The below is an example of fetching a single row.

call     count       cpu    elapsed       disk      query
current        rows

------- ------ -------- ---------- ---------- ---------- ----------

Parse        1      0.00       0.00          0          0
0           0
Execute      2      0.03       0.04          0          0
1           0
Fetch        1     20.59      57.66       8806     152983
150           1

------- ------ -------- ---------- ---------- ---------- ----------

total        4     20.62      57.70       8806     152983
151           1

Received on Thu Jul 23 1998 - 16:59:37 CDT