Hi,

I have below trace information for a SQL in tkprof trace file

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 93 0.07 0.07 0 0 0 0
Fetch 187 267.75 268.20 0 40955055 0 93
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 280 267.82 268.28 0 40955055 0 93

Here there are 93 execution and 93 rows returned.And fetch is almost double that is 187, where is that extra one fetch is taking place.
Why fetch is two times compared to execute

Thanks,
Girish

SQL> set serverout on
SQL> declare
  2    cursor C is select * from dual;
  3    x varchar2(1);
  4    fetch_count int := 0;
  5  begin
  6    open C;
  7    loop
  8      fetch_count := fetch_count + 1;
  9      fetch C into x;
 10      exit when c%notfound;
 11    end loop;
 12    close C;
 13    dbms_output.put_line('fetches = '||fetch_count );
 14  end;
 15  /
fetches = 2

PL/SQL procedure successfully completed.