Re: Open_cursors

From: devdewboy <devdewboy_at_hotmail.com>
Date: Fri, 27 Apr 2001 09:24:12 -0700
Message-ID: <MchG6.4$wN5.11675@news.pacbell.net>

'morning,

(1)
This is non-significant.
(2)
Remember the Open Cursor parameter applies to each session so 500 is representative of each session. A cursor is allocated as each statement is executed (implicit and explicit) so for each SELECT, INSERT, DELETE and UPDATE a cursor is opened. For DML statements and Implicit SELECTS, Oracle handles the closing of the cursor. Explicit SELECTs, you contronl these programatically.

There is a lot of information on this subject on Metalinks if you have an account or maybe just search their site.

"Ivan Bajon" <bajon_at_nospam@worldonline.dk> wrote in message news:9cbdjh$jli$1_at_news.inet.tele.dk...
> Hi fellow Oracologists
>
> (NT - 8.1.6)
>
> Could someone please tell me
>
> 1) How much space in bytes does each cursor take up? (init.ora
open_cursors)
> 2) If open_cursors=500, is space allocated for all 500 for every process
> when the process starts or are they allocated and freed dynamically?
>
> Thanks in advance,
> Ivan Bajon
>
>
>
Received on Fri Apr 27 2001 - 11:24:12 CDT