KB Article #44946

Setting max number of open cursor

Problem

Where to set the maximum number of open cursors used during data base access from any EXEC SQL statements within message builder code?


Resolution

You can set the open_cursors parameter in  "init.ora.xxxxx" configuration file located in C:\Oracle\Admin\<DBName>\pfile\init.ora.xxxxxx.