Oracle A423961 Manual Do Utilizador

Página de 202
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