Forum OpenACS Development: Re: Doing things the old-fashione way with ns_ora

Collapse
4: Re: Doing things the old-fashione way with ns_ora (response to 1)
Posted by Dirk Gomez on 09/10/03 04:00 PM
Can't you do an alter system set cursor_sharing=force to test it? (Or is it one of these pesky parameters that can only be changed with restarting the instance?)

Otherwise: you could also look into DDL triggers namely on-login triggers granted they are already available on your Oracle version.

Collapse
5: Re: Doing things the old-fashione way with ns_ora (response to 4)
Posted by Raad Al-Rawi on 09/12/03 05:35 PM
Yep - it's a dynamic parameter, so it is possible to set it instantly for the duration of the instance! :O

<Raad>