This appendix contains the z/OS-specific allowed, default, and maximum values for Oracle initialization and storage parameters. For a complete discussion of these parameters, refer to Oracle Database Reference. To find out which parameters described in Oracle Database Reference are supported or not supported by Oracle Database for z/OS, refer to Oracle Database Installation Guide for IBM z/OS on System z .
The topics in this appendix include:
The following table lists the Oracle Database initialization parameters that have z/OS-specific defaults or limits. You can separate the keywords with commas or blanks. For more information, refer to "Oracle Initialization Parameter Considerations" in Chapter 3, "Configuring a Database Service and Creating a New Database."
Table B-1 Initialization Parameters with z/OS-Specific Defaults or Limits
Parameter | Default | Maximum | Minimum |
---|---|---|---|
None |
Not supported |
Not supported |
|
AUDIT_FILE_DESTFoot 1 |
0 (zero) means "do not write SMF records" |
255 |
128 |
N/A |
N/A |
N/A |
|
None |
Not supported |
Not supported |
|
None |
Not supported |
Not supported |
|
N/A |
Limited by address space size |
0 |
|
1 |
N/AFoot 2 |
N/A |
|
&ORAPREFD..&ORASRVN..DFLCNTL.DBF |
N/A |
N/A |
|
None |
Not supported |
Not supported |
|
N/A |
N/A |
N/A |
|
N/A |
Limited by address space size |
65,536 |
|
0 - only 4, 8, 16, and 32 are supported for n |
Limited by address space size |
0 |
|
N/A |
Limited by address space size |
N/A |
|
4096 |
32768 |
4096 |
|
N/A |
23 |
N/A |
|
N/A |
29 |
N/A |
|
Derived |
256 |
1 |
|
N/A |
N/A |
N/A |
|
N/A |
65,534 |
N/A |
|
N/A |
Limited by address space size |
0 |
|
N/A |
Limited by address space size |
0 |
|
0 |
N/A |
N/A |
|
&ORAPREFD.&ORASRVN.DRn.DAT |
None |
None |
|
N/A |
1 |
0 |
|
N/A |
Limited by address space size |
0 |
|
N/A |
No limit |
0 |
|
N/A |
Limited by address space size |
0 |
|
N/A |
Limited by address space size |
N/A |
|
None |
Not supported |
Not supported |
|
NULL |
None |
None |
|
"T%T.S%S.R%R" |
None |
None |
|
16384 |
Limited by address space size |
N/A |
|
N/A |
N/A |
N/A |
|
None |
1 |
0 |
|
None |
Not supported |
Not supported |
|
None |
Limited by address space size |
0 |
|
AMERICAN |
N/A |
N/A |
|
AMERICA |
N/A |
N/A |
|
N/A |
Limited by address space size |
0 |
|
N/A |
Limited by address space size |
10240 |
|
N/A |
Limited by address space size |
1 |
|
OPS$ |
None |
None |
|
N/A |
N/A |
N/A |
|
2 |
N/A |
N/A |
|
Derived |
Limited by address space size |
N/A |
|
Number of processors minus 1. |
Limited by PARALLEL_ MAX_SERVERS |
0 |
|
N/A |
Limited by address space size |
0 |
|
N/A |
N/A |
N/A |
|
The actual SGA size (This parameter should not be specified on z/OS) |
N/A |
N/A |
|
0 (SGA tuning disabled) |
N/A |
64 |
|
None |
Not supported |
Not supported |
|
32000000 |
Limited by address space size |
4194304 |
|
N/A |
Limited by address space size |
N/A |
|
N/A |
N/A |
N/A |
|
&ORAPREFD..&ORASRVN..ARCHLOG. |
None |
None |
|
N/A |
Limited by address space size |
0 |
|
0 (Default is recommended value on z/OS) |
N/A |
N/A |
|
N/A |
N/A |
N/A |
|
5 |
34 |
N/A |
|
None |
Not supported |
Not supported |
Footnote 1 More information about using this parameter can be found in the section "Oracle Initialization Parameter Considerations" in Chapter 3, "Configuring a Database Service and Creating a New Database."
Footnote 2 N/A means that the platform-specific value is the same as the generic value.
Oracle database files, with exceptions, are limited to 4 GB each in size. The exceptions are as follows:
Control files, which are limited to 20,000 logical blocks of size DB_BLOCK_SIZE
Bigfile tablespace files, which are limited to the lesser of 4 GB blocks of size DB_BLOCK_SIZE, or, the maximum size of an extended-format extended addressability data set (up to 59 volumes or 16, if striping). For more information, refer to the IBM document DFSMS: Using Data Sets.
A maximum of 255 redo log files can be specified for a database.
A database can contain up to 65, 534 datafiles over all tablespaces. A single smallfile tablespace is limited to 4094 datafiles.
This section lists the parameters for the CREATE CONTROLFILE and CREATE DATABASE SQL statements that have z/OS-specific defaults or limits.
The parameters for the CREATE CONTROLFILE SQL statement are listed in the following table:
Table B-2 CREATE CONTROLFILE Parameters with z/OS-Specific Defaults or Limits
Parameter | Default | Maximum | Minimum |
---|---|---|---|
WE8EBCDIC1047 |
N/A |
N/AFoot 1 |
|
32 |
65534Foot 2 |
N/A |
|
1 |
15 |
N/A |
|
32 |
256 |
N/A |
|
2 |
5 |
N/A |
|
100 |
65534 |
N/A |
Footnote 1 N/A means that the platform-specific value is the same as the generic value.
Footnote 2 Specifying MAXDATAFILES larger than 40,000 requires using a value of 8K or larger for the DB_BLOCK_SIZE initialization parameter.
The parameters for the CREATE DATABASE SQL statement are listed in the following table:
Table B-3 CREATE DATABASE Parameters with z/OS-Specific Defaults or Limits
Parameter | Default | Maximum | Minimum |
---|---|---|---|
WE8EBCDIC1047 |
N/A |
N/AFoot 1 |
|
Refer to "Oracle Database Files" in Chapter 4, "Defining z/OS Data Sets for the Oracle Database." |
N/A |
16K or one VSAM control area, whichever is larger |
|
Refer to "Oracle Database Files" in Chapter 4, "Defining z/OS Data Sets for the Oracle Database." |
N/A |
N/A |
|
32 |
65534Foot 2 |
N/A |
|
1 |
15 |
N/A |
|
32 |
256 |
2 |
|
2 |
5 |
N/A |
|
N/A |
N/A |
N/A |
Footnote 1 N/A means that the platform-specific value is the same as the generic value.
Footnote 2 Specifying MAXDATAFILES larger than 40,000 requires using a value of 8K or larger for the DB_BLOCK_SIZE initialization parameter.