Re: Open_cursors

From: Ivan Bajon <bajon_at_nospam@worldonline.dk>
Date: Fri, 27 Apr 2001 11:27:48 +0200
Message-ID: <9cbdoj$jvu$1@news.inet.tele.dk>

As a matter of fact, I need to know the same regarding enqueue_resources (I know that these are not allocated for each process but for the system as a whole).

Regards,
Ivan Bajon

"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 - 04:27:48 CDT