open_cursors

[Anon]

sir,
plase give me answer . how to set parameter.can i set in init.ora file
open_cusors = 100
but in init.ora are not defined open_cursors

but i think site effact.

error

ora -01000 maximum open cursors exceed

[Anon]

If there isn't an open_cursors in your init.ora, then the system will take a default value which is too low for many applications. Just add the line to your init.ora and restart the database instance.

By the way... You might want to go to 255 open cursors instead of just 100. The difference in memory utilization is relatively small.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com