Oracle Parallel Server Question

From: Esme Venter <esmev_at_medscheme.co.za>
Date: Tue, 4 Aug 1998 11:23:54 +0200
Message-ID: <6q6jqt$h13$1@hermes.is.co.za>

Hi
We run OPS on twelve nodes for our Datawarehouse. Data in a few large tables get updated twice monthly.
All related indexes are dropped prior to inserts/updates and recreated afterwards.
I need some help to make sure that I have set my GC_FILES_TO_LOCKS parameter correctly.

Currently I have set it as follows :

For SYSTEM datafile : 500
For ROLLBACK datafiles : 500 ( 12 datafiles which is one datafile containing private rolback segments for EACH of the twelve nodes.) For TEMPTS1 : 100 (10 datafiles)
For TEMPTS2 : 100 (10 datafiles)

GC_DB_LOCKS = 4001 (So all the other datafiles share the remaining 2801 locks.)

Firstly, The OPS manual suggests that no PCM locks should be assigned to files which only hold ROLLBACK SEGMENTS or TEMPORARY data.

Question: Does this mean I have to omit the datafiles belonging to ROLLBACK and TEMP tablespaces from the GC_FILES_TO_LOCKS parameter or should I include them with a value of 0?

Thanks in advance. Received on Tue Aug 04 1998 - 04:23:54 CDT