| tkprof fetch count [message #211185] |
Wed, 27 December 2006 01:34  |
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
|
Member |
|
|
Hi,
Can you explain whyn after executing a "Select" statement from a single table, which return "N" rows it is showing "Count" of "Fetch" as "2N" ?
Thanks
|
|
|
|
|
|
| Re: tkprof fetch count [message #211201 is a reply to message #211185] |
Wed, 27 December 2006 03:09  |
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
|
Member |
|
|
Fetch Count is showing 4 for retrieving 2 rows of following table.
SQL> select * from seth ;
A B
----- ------
1 test1
2 test2
Trace file generated from this statement looks like
************************************************************
select *
from seth
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.01 0.00 0 8 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 0 16 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.01 0.00 0 24 0 4
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 58
Rows Row Source Operation
------- ---------------------------------------------------
2 TABLE ACCESS FULL SETH (cr=8 pr=0 pw=0 time=97 us)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
