Oracle Database Specifications for Windows

Sample File
Oracle Database provides an annotated sample initialization parameter file with alternative values for initialization parameters.

SGA_MAX_SIZE Parameter
Parameter SGA_MAX_SIZE holds the maximum size that System Global Area (SGA) can reach for a particular instance.
Beginning with Oracle9i release 1 (9.0.1), Oracle Database can change its SGA configuration while the instance is running
If no SGA_MAX_SIZE value is specified, then Oracle Database selects a default
value that is the sum of all components specified or defaulted at initialization time. If SGA_MAX_SIZE specified in the initialization parameter file is less than the sum of all components specified or defaulted to at initialization time, then the setting of SGA_MAX_SIZE in the initialization parameter file is ignored.

Initialization Parameters Without Windows-Specific Values
AUDIT_FILE_DEST
Not supported on Windows and should not be added to the initialization parameter file
DB_WRITER_PROCESSES
Supported, but typically unnecessary due to Windows asynchronous I/O capabilities
COMPATIBLE_NO_RECOVERY
Uses default value set in Oracle Database kernel (no Windows-specific value)
BACKGROUND_CORE_DUMP
Specifies whether Oracle Database includes SGA in core file for Oracle Database background processes
SHADOW_CORE_DUMP
Specifies whether Oracle Database includes SGA in core file for foreground (client) processes
CORE_DUMP_DEST
Specifies directory where Oracle Database dumps core files
CPU_COUNT
Oracle Database automatically sets value to number of processors available for your Oracle Database instance
HI_SHARED_MEMORY_ADDRESS
Not applicable to Windows
SHARED_MEMORY_ADDRESS
Not applicable to Windows
LARGE_POOL_SIZE
Uses maximum value limited by available memory
LOG_BUFFER
Starter database uses value set in Oracle Database kernel (no Windows-specific value). The Custom database creation option of Database Configuration Assistant enables you to customize the value for this parameter.
SPIN_COUNT
Uses default value set in Oracle Database kernel (no Windows-specific value)

Uneditable Database Initialization Parameters
They cannot be modified after you have created the database.
CHARACTER SET
Specifies database Globalization Support character set to use. This parameter can be set only when you create the database.
DB_BLOCK_SIZE
Specifies size in bytes of standard Oracle Database blocks.
DB_NAME
Specifies name of the database to be created. Database name is a string of eight characters or less. You cannot change the name of a database.

Calculating Database Limits
Maximum File Sizes
Maximum file size for a FAT file 4 GB
Maximum file size in NTFS 16 Exabytes (EB)
Maximum database size 65,536 * 64 GB equals approximately 4 Petabytes (PB)
Maximum control file size 20,000 blocks