Global_Buffers[=(Total=i,User_Limit=j)]
Allows you to set the basic global buffer parameters on each
RMU Open command. If you specify the Global_Buffers qualifier,
you can optionally specify values for the Total and User_Limit
parameters:
o Total is the number of global buffers per node to allocate for
this opened instance of the database (minimum = 5, and maximum
o User_Limit is the maximum number of global buffers to be
allotted to any given user (minimum = 5, maximum = Total).
The default values for Total and User_Limit are set by:
o The RMU Open command explicitly
o Values determined at the time the database was created
If you do not specify a value for the Total or User_Limit
options, the values are determined based on what they were when
the database was created.
If a database does not have global buffers enabled, the Global_
Buffers qualifier is ignored. Use the RMU Dump command to see
if global buffering is enabled or disabled. The RMU Dump command
also shows the global buffer count and the maximum global buffer
count per user. For example:
$ RMU/DUMP MF_PERSONNEL
*------------------------------------------------------------------
* Oracle Rdb V7.0-00 22-SEP-1995 10:11:51.14
*
* Dump of Database header
* Database: DISK1:[DATABASE]MF_PERSONNEL.RDB;1
*
*-------------------------------------------------------------------
Database Parameters:
Root filename is "DISK1:[DATABASE]MF_PERSONNEL.RDB;1"
Created at 7-APR-1994 16:50:09.01
Oracle Rdb structure level is 70.0
Maximum user count is 50
Maximum node count is 16
Database open mode is AUTOMATIC
Database close mode is AUTOMATIC
Database is available for READ WRITE access
Snapshot mode is NON-DEFERRED
Statistics are enabled
Storage Areas...
- Active storage area count is 10
- Reserved storage area count is 0
Buffers...
- Default user buffer count is 20
- Default recovery buffer count is 20
- Global buffers are enabled <--------
- Global buffer count is 250 <--------
- Maximum global buffer count per user is 5 <--------
- Buffer size is 6 blocks
.
.
.
Derived Data...
- Global section size
With global buffers disabled is 70962 bytes
With global buffers enabled is 975992 bytes
.
.
.
The Global_Buffers qualifier is a positional qualifier.