Home » RDBMS Server » Server Administration » parallel query error
parallel query error [message #379110] Sun, 04 January 2009 23:45 Go to next message
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
Re: parallel query error [message #379115 is a reply to message #379110] Mon, 05 January 2009 00:04 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Check Metalink Document: 138457.1

Babu
Re: parallel query error [message #379116 is a reply to message #379115] Mon, 05 January 2009 00:05 Go to previous messageGo to next message
bsac14
Messages: 6
Registered: December 2008
Junior Member
I have no access to it
Please give your comments
Re: parallel query error [message #379117 is a reply to message #379116] Mon, 05 January 2009 00:08 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Requesting to you please provide your four decimal oracle version.

Babu
Re: parallel query error [message #379118 is a reply to message #379117] Mon, 05 January 2009 00:10 Go to previous messageGo to next message
bsac14
Messages: 6
Registered: December 2008
Junior Member
9.2.0.7.0
Re: parallel query error [message #379121 is a reply to message #379118] Mon, 05 January 2009 00:17 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello,

Your Operating System??

Babu
Re: parallel query error [message #379123 is a reply to message #379118] Mon, 05 January 2009 00:20 Go to previous messageGo to next message
bsac14
Messages: 6
Registered: December 2008
Junior Member
uname -a
HP-UX dygkr01 B.11.11 U 9000/800 1111424627 unlimited-user license
Re: parallel query error [message #379124 is a reply to message #379123] Mon, 05 January 2009 00:28 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

I don't have right's to copy metalink document.

I'm suggesssting to you;

1/ Try to increase parallel_max_servers parameter & retry the operation

If it's not help

1/ Try to generate Trace file & call Oracle Support (Becuase this is interal erros)

Re: parallel query error [message #379128 is a reply to message #379124] Mon, 05 January 2009 00:36 Go to previous messageGo to next message
bsac14
Messages: 6
Registered: December 2008
Junior Member
The current value for

parallel_max_servers integer 100

Pls suggest how much I can increase
Re: parallel query error [message #379156 is a reply to message #379128] Mon, 05 January 2009 03:14 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
PARALLEL_MAX_SERVERS specifies the maximum number of parallel execution processes and parallel recovery processes for an instance. As demand increases, Oracle increases the number of processes from the number created at instance startup up to this value.

If you set this parameter too low, some queries may not have a parallel execution process available to them during query processing. If you set it too high, memory resource shortages may occur during peak periods, which can degrade performance.


Please cal oracle support.

Babu
Previous Topic: Oracle 6 DB Problem
Next Topic: Oracle Jobs failed
Goto Forum:
  


Current Time: Sat Dec 10 01:34:00 CST 2016

Total time taken to generate the page: 0.10698 seconds