pro*c performance question

From: Saeed Talebbeik <saeed_at_ov.com>
Date: 3 Nov 1993 22:34:43 GMT
Message-ID: <2b9bm3$hbv_at_wylie.ov.com>


I have an application that executes many select statements and manuipulates explicit cursors by doing declare, open , fetch, close.

In order to hold all the cursors (implicit and explicit) open at all times and thus reduce the amount of parsing I have compiled my program with options "hold_cursor=yes" and "release_cursor=no" . According to Oracle's documentation even if I issue a "close cursor" statement the cursor will still stay open and I will avoid reparsing of the statements thus the performance will be increased.

After compiling my program I see absolutely no change in the amount of time that my program and the oracle engine eats !

If anyone has done any pro*c tuning before and has any insight into what the problem might be , please post your replies.

                                                                   Regards,
                                                                  <<<saeed>>>
Received on Wed Nov 03 1993 - 23:34:43 CET

Original text of this message