Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Forcing an ALTER SESSION at session startup - How?

Re: Forcing an ALTER SESSION at session startup - How?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 19 Oct 2000 16:55:35 +0200
Message-ID: <971976220.1628.0.pluto.d4ee154e@news.demon.nl>

If you are using 8i you can use an after logon trigger. If you are not using 8i this is a reason to upgrade, because they are really no other mechanisms in prior versions.

Hth,

Sybrand Bakker, Oracle DBA

"Syltrem" <syltrem_at_videotron.ca> wrote in message news:TiDH5.1075$5y.4674_at_wagner.videotron.net...
> 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!
>
>
>
Received on Thu Oct 19 2000 - 09:55:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US