The following database parameters in the General group determine the general properties of the database instance:
CACHE_SIZE |
Size of the I/O buffer cache in pages |
INSTANCE_TYPE |
|
KERNELVERSION |
Version of the database software |
LOG_MIRRORED |
Specifies whether the log area is mirrored, possible values: YES | NO This parameter is relevant only when you create a mirror volume with the Database Manager CLI. This value is changed implicitly when you create a mirror volume with the Database Manager GUI. |
LOG_SEGMENT_SIZE |
Size of a log segment in pages |
MAXBACKUPDEVS |
Maximum number of files or tape devices in a Group of Parallel Backup Media The maximum value for MAXBACKUPDEVS is 32. |
MAXCPU |
Specifies the number of processors across which the user tasks can be distributed Remember that the operating system resources of your computer must also be free for other processes, not just the database. If you are using a single processor computer, you should choose a value of 1 for the MAXCPU. |
MAXDATAVOLUMES |
Maximum number of data volumes |
MAXLOCKS |
Maximum number of entries in the lock list, in which the locks of all users and their lock requests are stored |
MAXLOGVOLUMES |
Maximum number of log volumes |
MAXUSERTASKS |
Specifies the maximum possible number of simultaneous database sessions (user tasks) If this number has been reached, then no other user can log on to this database instance. For this reason, you must monitor MAXUSERTASKS as a critical operational parameter, If you configure this parameter too high, then the space required for addresses rises (particularly the Shared Memory). |
RUNDIRECTORY |
Run directory of the database instance |
You can display more information about the parameters with the Database Manager.