Cursor with full table select running slow
I have a cursor which is looping a full table, I have traced the session and identified that the elapsed time is keep on increasing with the increase in number of fetches. The table is of 150MB with 1million rows.
below is from the trace ouput for each hour. Please suggest on why the fetch is taking time
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 36409 4.39 8.63 1064 56159 0 36409
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 36409 4.39 8.63 1064 56159 0 36409
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------