Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: open_cursors setting

Re: open_cursors setting

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 14 Oct 2000 11:57:04 +0800
Message-ID: <39E7D98F.6FD5@yahoo.com>

Jim Poe wrote:
>
> Can anyone advise us on how to set open_cursors in the initialization file.
> Related to this is how do we determine which cursors to leave open during
> the session or close immediately after use?
>
> Obviously, a cursor opened and used repeatedly within a loop would be kept
> open until the loop was finished. But, most of our sql consists of
> parameterized queries that are executed as the user navigates through the
> application. These queries may be used repeatedly ( in human time ) or
> infrequently, or not at all during a session. Does it make sense to open
> these cursors and leave them open during the entire session?
>
> Thanks
> --
> Jim Poe ( jpoe_at_fulcrumit.com )

I typically start at 1000 for open_cursors since the default (50 in most platforms) is so woefully low...

You may want to check out the session_cached_cursors parameters to also assist ...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me... 
  its the voices in yours.
Received on Fri Oct 13 2000 - 22:57:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US