Re: Database trigger or Intermedia complexicity :closed

From: Praful Thakkar <thakkar_praful_at_yahoo.com>
Date: Fri, 28 Apr 2000 06:45:27 -0700 (PDT)
Message-Id: <10481.104411@fatcity.com>

Hi,

Drbgdml.sql is nothing but an SQL script continually scanning for DML to do on any index. It remains logged on and uses the concept of syncing the domain index. In this script, sleep time is just 5 seconds so chances for domain index getting fragmented is very high. On the other hand, CTXSRV builds the batch, which may contain many more words to sync simultaneously. This depends on the default memory allocated to CTXSRV process. By specifying high default memory, chances of fragmentation of domain index are lower compared to the background process.

Another disadvantage is - you'll have to kill this background process when you shutdown the database. 'SHUTDOWN IMMEDIATE' to shutdown database may not work because of the active connection from this script. Even in 8.1.6, there is no mechanism equivalent to shutting down the CTXSRV for the background script.

BTW, you can modify the script to change sleep time for your needs. You can specify memory for syncing domain index, too. Alternately, use DBMS_JOB to submit the job for syncing the domain indexes every 'n' second.

HTH.

• Praful
  • Ian MacGregor <ian_at_SLAC.Stanford.EDU> wrote:
    > "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!?
Talk to your friends online and get email alerts with Yahoo! Messenger. Received on Fri Apr 28 2000 - 08:45:27 CDT