| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Open Cursor Problem
A copy of this was sent to "AXK" <axk_at_fernbach.com>
(if that email address didn't require changing)
On Fri, 11 Jun 1999 08:20:51 +0200, you wrote:
>Hello,
>
>i asked my college for describe the exactly Problem.
>
>The Problem is:
>
>In a form i can make any open, fetch, close cursor.
>After this, i can see in the v$open_cursor 1 open Cursor.
>The record from the form stay in this form.
>When i start again the same form and i make again
>the open, fetch,close curse he see in the v$open_cursor
>2 open cursor and so on...
>The parameter for open_cursor in the init.ora is correct.
>
>We use Forms 4.5.7.1.6 and Oracle Server 7.3.4.2.
>
>Is this an Forms problem or what??
>
No, plsql caches open cursors for you. In versions less then 8.1 you can control this with 'close_cached_open_cursors' in your init.ora but i would recommend you INCREASE open_cursors to some large number (500, 1000 say) instead of decreasing your performance by really truely closing cached cursors. Forms does alot of the same sql over and over and over. You really want these things cached.
>Can anyone help me.
>
>Thanks.
>
>Axel
>
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--
 |
 |