Oracle support told me that the Intermedia background
process connects in a special way to the db and
because of that the on logon trigger is not fired.
- paquette stephane <stephane_paquette_at_yahoo.com> a
icrit:
> Hi all,
>
> We're using Intermedia on Oracle 8.1.5/Solaris 2.6.
> The ctxsys user is always in the temp tablespace. So
> to cure that, I've created a database trigger on
> logon
> of ctxsys.schema. This trigger calls a stored proc
> that increase sort_area_size.
>
> When connecting with sqlplus as ctxsys, the
> sort_area_size is really increased.
>
> When the connection is made by ctxsrv with ctxsys,
> the
> sort_area_size is not increased .
> Why ?
>
>
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>
> __________________________________________________
> Do You Yahoo!?
> Send online invitations with Yahoo! Invites.
> http://invites.yahoo.com
>
> ---
> You are currently subscribed to oracle as:
> stephane_paquette_at_yahoo.com
> To unsubscribe send a blank email to
> leave-oracle-163635Y_at_telelists.com
> or visit the Oracle mailing list on the Web at:
>
http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle
>
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger.
Received on Thu Apr 27 2000 - 07:52:02 CDT
