Re: Database trigger or Intermedia complexicity :closed

"ctxsrv" is being deprecated. The program $ORACLE_HOME/ctx/sample/scripts/drbgdml.sql has been provided to take its place in
8.1.6, although ctxsrv is present on 8.1.6 as well.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

paquette stephane wrote:
>
> 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.
> http://im.yahoo.com/
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Apr 27 2000 - 10:40:51 CDT