Key Tuning Parameters in theONCONFIG File

System Configuration

NETTYPE # Override sqlhosts nettype parameters

RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor

NUMCPUVPS 1 # Number of user (cpu) vps

SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

NOAGE 0 # Process aging

AFF_SPROC 0 # Affinity start processor

AFF_NPROCS 0 # Affinity number of processors

Previous slide

Next slide

Back to first slide

View graphic version