|
|
|
|
|
|
|
|
|
|
|
|
|
Re: How to find the no of records selected by a curcor before processing the rows? [message #289854 is a reply to message #289789] |
Wed, 26 December 2007 05:05   |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Thank you Maaher.
why I tried to get this number is,
I tried to load a table from a core table.
I am selecting the values from core table using cursor.
But the execution time differs even the same no of records processed.
SQL> begin
2 LOAD_CORE_PERFORMANCE;
3 end;
4 /
hi23906
PL/SQL procedure successfully completed.
Elapsed: 00:04:52.03
SQL> /
hi23916
PL/SQL procedure successfully completed.
Elapsed: 00:05:51.08
SQL> /
hi23916
PL/SQL procedure successfully completed.
Elapsed: 00:07:15.00
the number with hi is the number of cursor rows.
Even this numbers are same. It takes different time.
Please help me.
|
|
|
|
|
|
|
|