Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Forcing an ALTER SESSION at session startup - How?
The parameter is
serialixable=true
I have never tried running a system with this parameter set, so I know nothing about side-effects and performance impact. It is probably not a good idea to use it.
One detail to check - you should set INITRANS to at least 2 on tables and 3 on indexes if you want to try it.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Syltrem wrote in message ...Received on Sun Oct 22 2000 - 13:21:03 CDT
>I'm using 7334.
>
>What is the obsolete parameter, if you think it would work for me?
>
>Thanks!
>
>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
>news:971971774.28538.0.nnrp-13.9e984b29_at_news.demon.co.uk...
>>
>> There is an 'obsoleted' parameter.
>> However for 8.1.6 you could create a
>> database-level trigger
>> create trigger XYZ on logon ......
>>
>> This can be made global (any logon to database)
>> or for a specific user (SCOTT.schema).
>>
>> It is best to test logon triggers against a single
>> schema before going global.
>>
>>
>> --
>>
>> Jonathan Lewis
>> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>>
>> Syltrem wrote in message ...
>> >Hi!
>> >
>> >I would like to do an
>> >ALTER SESSION ISOLATION_LEVEL=SERIALIZABLE
>> >when any user session starts (not in SQL*Plus!). This is for testing
>> >purposes, and if the users (or application) like it I may need it for
the
>> >prod db.
>> >
>> >Is there a way to do this? Is there a startup parameter that will do it?
>> >
>> >Thanks!
>> >
>> >
>> >
>>
>>
>
>