| parallel query error [message #379110] |
Sun, 04 January 2009 23:45  |
bsac14
Messages: 6
Registered: December 2008
|
Junior Member |
|
|
Hi ,
We are getting the following error in our database continously for many days.
Oracle version : 9.2.x
ORA-00600: internal error code, arguments: 15709, [1], [1], 9], [, ], [, []
ORA-12805: parallel query server died unexpectedly
Oracle suggest increase parallel_max_servers.
We now got a shutdown approved on this live server.
Can you please tell us whether all the parallel related parameters also needs to be changed.Pls have a look at the existing setup and advice what value we need to set.
NAME TYPE VALUE
------------------------------------ -----------
fast_start_parallel_rollback string LOW
log_parallelism integer 1
parallel_adaptive_multi_user boolean FALSE
parallel_automatic_tuning boolean FALSE
parallel_execution_message_size integer 2152
parallel_instance_group string
parallel_max_servers integer 100
parallel_min_percent integer 0
parallel_min_servers integer 4
parallel_server boolean FALSE
parallel_server_instances integer 1
parallel_threads_per_cpu integer 2
recovery_parallelism integer 0
Please help urgently
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
