Re: maximum open cursors reached

Read the installation manual - I'll charge you 3 minutes of my time: <quote>
The following are the recommended minimum settings.

      compatible = 8.1.6
       max_enabled_roles = 30
       sort_area_size = 262144
       sort_area_retained_size = 65536

       hash_area_size = 1048576
       optimizer_index_caching = 50
       optimizer_index_cost_adj = 25
       shared_pool_size = 32000000

       db_block_buffers = 2000
       open_cursors = 1000
       processes = 100
       db_file_multiblock_read_count=16 # for a 4K Oracle block size
       db_file_multiblock_read_count=32 # for a 2K Oracle block size
       db_file_multiblock_read_count=8  # for a 8K Oracle block size

--
Frank
Michiel Kuperus <cube_at_dds.nl> schreef in berichtnieuws
0E16861EE7BCD111BE9400805FE6841F1241791B_at_c1s5x001.cor.srvfarm.origin-it.com.
..


> Hi,

>

> I've a small (but show stopping) problem:


>

> In Designer 6, after I created some things (table, columns, etc..) I get

 an


> error: maximum number of open cursors

>

> After some reading I found there is a setting in init.ora (OPEN_CURSOR).


>

> Question:

> 1. Is this setting in init.ora the way to get rid of this problem? (and

> ifso, is there a need of a reboot?)

> 2. What is a good number for a small repository with few connections?

>

> vital info:

> Server:Oralce EE 816r2 on NT4SP5, 256Mb, one database about 2Gb

> Client: Designer6 on NT4SP6

>

> I know this question has probably been posted before: Is there a(n)

> (official) FAQ?

>

> Thnx in advance,

> Michiel

>

>

>