-
I dunno how the instances is 1 we are not using parallel server.
The parallel server is set to false but parallel server instances is 1 which is default as per foll:
PARALLEL_SERVER_INSTANCES
Parameter type: Integer
Parameter class: Static
Default value: 1
Range of values: Any non-zero value
PARALLEL_SERVER_INSTANCES is an Oracle Parallel Server parameter that specifies the number of instances currently configured. You must set this parameter for every instance. Normally you should set this parameter to the number of instances in your Oracle Parallel Server environment. A proper setting for this parameter can improve memory use.
Oracle uses the value of this parameter to compute the default value of the LARGE_POOL_SIZE parameter when the PARALLEL_AUTOMATIC_TUNING parameter is set to TRUE.
In fact none of my databases use parallel server but in dba_jobs view they all shoh instances as 1 and the jobs are running fine except for this one???
Thanx
KN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|