Yes, you can alter the storage characteristics of
these objects and in rep environments with a high
volume of tx's or calls per tx you will definitely
need to, as you discovered. I also recommend
relocating them out of the system tablespace as well.
The following doc on MetaLink has details for
relocating the tables:
Note: 1037317.6 "MOVE REPLICATION SYSTEM TABLES USING
EXPORT/IMPORT FOR ORACLE 8.0.X"
I have no idea what the upper limit on tx id's is, but
I suspect that like the max SCN value it's not
something you need to worry about.
HTH,
- Anita
- MVallath_at_cs.com wrote:
>
> 1. We are doing some volume testing in our
> replicated environment and
> have encountered maxextents errors on a variety of
> Oracle objects which
> support replication, including the deferred queue.
> These objects are all
> defined with initial and next extent sizes of 16K
> and a maxextents of 505.
> To get our test to run, we changed the maxextents
> to unlimited on each
> object that encountered the error. We started to
> play with the next
> extents sizes, but thought better of it and
> stopped.
>
> None of the Oracle documentation mentions
> configuring these objects, so is
> what we're encountering typical? Has anyone else
> run into these limits
> and modified them? Should we go through and set
> all DEF$ objects to
> unlimited?
>
> The specific objects that we had trouble with, owed
> by SYSTEM, were:
>
> -- Deferred queue table DEF$_AQCALL and two indexes
> on it: PK index and
> DEF$_TRANORDER
> -- Table DEF$_CALLDEST and two indexes on it:
> DEF$_CALLDEST_PRIMARY and
> DEF$_CALLDEST_N2
>
> 2. Related to this is placement of the replication
> objects owned by
> SYSTEM. Should they be located in SYSTEM or built
> in a separate
> tablespace? In our installation, some objects are
> in SYSTEM (like the
> deferred queue) and some are in TOOLS (because we
> typically change
> SYSTEM's default tablespace to TOOLS and we ran
> catrep.sql after doing
> so).
>
> Should SYSTEMs default tablespace be left as
> SYSTEM?
> Is it feasible to build the replication objects,
> especially the deferred
> queue, in their own tablespace (and not SYSTEM)?
>
> 3. How does Oracle generated deferred_tran_ids?
> Can we ever run out of
> numbers?
>
> Thanks for the help!
>
> Sd
> --
> Author:
> INET: MVallath_at_cs.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
> also send the HELP command for other information
> (like subscribing).
Received on Tue Jul 11 2000 - 07:24:27 CDT
