Oracle A423961 - Manual (Page 133)

C – 5 Initialization Parameter Files
Range of Values Default Value Parameter Name
OPEN_CURSORS 50 1 – Unlimited
OS_AUTHENT_PREFIX OPS$ any character string
PROCESSES 25 3 – Unlimited
REMOTE_LOGIN_PASSWORDFILE shared shared, exclusive, none
SHARED_POOL_SIZE 6,500,000 300K – Unlimited
SORT_AREA_SIZE 65536 0 – Unlimited
SORT_READ_FAC 20 0 – Unlimited
SORT_SPACEMAP_SIZE 512 0 – Unlimited
TEMPORARY_TABLE_LOCKS SESSIONS 0 – Unlimited
TRANSACTIONS_PER_ROLLBACK_SEGMENT 30 1 – 255
USER_DUMP_DEST %RDBMSnn%\TRACE Any valid directory
These are the default values for the Replication Database:
• global_name = true
• job_queue_processes = 2
• job_queue_interval =10
• snapshot_refresh_processes = 2
• shared_pool_size = 10,000,000