Help me read my TKPROF output

From: Aniruddha Kortikar <kortikar_at_mipos2.intel.com>
Date: 14 Jan 93 21:38:57 GMT
Message-ID: <C0v5Gz.LnM_at_inews.Intel.COM>

select * from vendor where vendor_name like '%ALD%'

            count     cpu    elap    phys      cr     cur    rows
Parse:          1       0       0       0       0       0
Execute:        1       0       0       0       0       2       0
Fetch:          1       0       0       0       3       0       1

Execution plan:
TABLE ACCESS (FULL) OF 'VENDOR'

---

1. cr means buffers recieved in consistent mode. (why is this > 0 even though there is nobody using the system, hence no update, mod or select on vendor (why all of it is not retrieved in cur - current mode ?)
2. what does 2 in cur-Execute mean ? (what does execute phase do in select ..)
3. why phys 0 everywhere ? does it mean it was all in memory ? (count(*) is 150 so with 16 MB memory that should be possible. - SGA is much smaller though!)

will anybody provide me with detailed meaning of all these terms.

regards,

Aniruddha Kortikar (kortikar_at_mipos2.intel.com)

---

E-mail : kortikar_at_mipos2.intel.com | A billion here, a billion there ... Phone(W): 408 765 5515 | pretty soon it adds upto real big money

---

Received on Thu Jan 14 1993 - 22:38:57 CET