1 – Alter
Alter=(Name=cachename,option(, ...))
Specifies the action to take on the named cache. You must
specify the cache name and at least one other option. The /Alter
qualifier may be specified multiple times on the command line.
Each /Alter qualifier specified operates on one unique cache
if no wildcard character (% or *) is specified. Otherwise, each
/Alter operates on all matching cache names.
o Name=cachename
Name of the cache to be modified. The cache must already be
defined in the database. You must specify the cache name
if you use the Alter qualifier. This parameter accepts the
wildcard characters asterisk (*) and percent sign (%).
o Backing_Store_Location=devdir
Specifies the name of the cache-specific default directory to
which row cache backing file information is written for the
specified cache. The database system generates a file name
(row-cache-name.rdc) automatically for each row cache backing
file it creates when the RCS process starts. Specify a device
name and directory name; do not include a file specification.
By default, the location is the directory of the database
root file unless a database-specific default directory or a
cache-specific default directory has been set.
o NoBacking_Store_Location
Specifies that there is no cache-specific default directory
to which row cache backing file information is written for the
specified cache.
o Drop
Specifies that the indicated row cache is to be dropped
(deleted) from the database.
o Shared_Memory=keyword
Specifies the shared memory type and parameters for the cache.
Valid keywords are:
- Type=option
Specify one of the following options:
* Process
Specifies traditional shared memory global section,
which means that the database global section is located
in process (P0) address space and may be paged from the
process working set as needed.
* Resident
Specifies that the database global section is memory
resident in process (P0) address space using shared
page tables. This means that the global section is fully
resident, or pinned, in memory, and uses less physical
and virtual memory (for process page tables) than a
traditional shared memory global section.
- Rad_Hint=n
NoRad_Hint
Indicates a request that memory should be allocated from
the specified OpenVMS Resource Affinity Domain (RAD). This
keyword specifies a hint to Oracle Rdb and OpenVMS about
where memory should be physically allocated. It is possible
that if the requested memory is not available, it will be
allocated from other RADs in the system. For systems that
do not support RADs, no Rad_Hint specification is valid.
The Rad_Hint keyword is valid only when the shared memory
type is set to Resident. If you set the shared memory type
to System or Process, you disable any previously defined
RAD hint.
Use Norad_Hint to disable the RAD hint.
o Slot_Count=n
Specifies the number of slots in the cache.
o Slot_Size=n
Specifies the size (in bytes) of each slot in the cache.
o Snapshot_Slot_Count=n
Specifies the number of snapshot slots in the cache. A value
of zero disables the snapshot portion for the specified cache.
o Sweep_Interval=n
Specifies the periodic cache sweep timer interval in seconds.
Valid values are from 1 to 3600.
o NoSweep_Interval
Disables the periodic cache sweep timer interval.
o Working_Set_Count=n
Specifies the number of working set entries for the cache.
Valid values are from 1 to 100.
2 – Backing Store Location=devdir
Specifies the name of the database-specific default directory to
which row cache backing file information is written. The database
system generates a file name (row-cache-name.rdc) automatically
for each row cache backing file it creates when the RCS process
starts up. Specify a device name and directory name; do not
include a file specification. The file name is the row-cache-name
specified when creating the row cache. By default, the location
is the directory of the database root file unless a database-
specific default directory or a cache-specific default directory
has been set.
3 – Disable
Disables row caching. Do not use with the Enable qualifier.
4 – Enable
Enables row caching. Do not use with the Disable qualifier.
5 – Log
Log
Nolog
Specifies whether the processing of the command is reported to
SYS$OUTPUT. Specify the Log qualifier to request log output and
the Nolog qualifier to prevent it. If you specify neither, the
default is the current setting of the DCL verify switch.
6 – NoBacking Store Location
Specifies that there is no database-specific default directory to
which row cache backing file information is written.