thanks, How can I find the number of cursors from within a schema?
"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
news:pajv3058jf0q7lf35lkg897srt72e6cij7_at_4ax.com...
> On Fri, 27 Feb 2004 22:45:17 GMT, "Karl Hungus"
> <nnnnndddddd_at_hotmail.com> wrote:
>
> >
> >The default number of cursors is 100. Is this setting per schema or for
the
> >whole DB?
> >
> >Under what circumstances would you want to raise this number?
> >
> >Thanks in advance,
> >Karl
> >
> Per *session*. And 100 is insufficient. 500 is more like it
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Feb 27 2004 - 17:23:16 CST
