Re: init.ora with JDBC

Sybrand Bakker wrote:

>
>
> As you can see in the v$parameter view the open_cursors parameter is a
> static parameter which can be changed only by modifying init.ora and
> bouncing the database. The number of open_cursors is a *per session*
> parameter and the cursors are precreated.

Ok. "bouncing the database?" What does that have to do with a "session"?

>
> The case insensitive parameter exists in toy databases like sqlserver and
> access only.
>

I agree those don't have flexibility by making case insensitivity all or nothing,
but the converse is true if one can't make case insensitivity at least a session parameter.

Thanks,

Dave

>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Sep 14 2001 - 23:11:00 CEST