Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12805 Errors

Re: ORA-12805 Errors

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 22 Dec 2004 18:43:07 +0100
Message-ID: <9ecjs0hq1sf91v1tkaan0pntcj04v0nqca@4ax.com>


On Wed, 22 Dec 2004 16:25:07 GMT, Don Seiler <don.seiler_at_cellcom.com> wrote:

>On Monday one of my developers was running horrible query that was
>supposed to be a join but he forgot to include the where clause. That
>query bombed with an ORA-12805 error about the parallel query dying. We
>don't explicitly have parallel query set up:
>
>SQL> show parameter para
>
>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 2148
>parallel_instance_group string
>parallel_max_servers integer 5
>parallel_min_percent integer 0
>parallel_min_servers integer 0
>parallel_server boolean FALSE
>parallel_server_instances integer 1
>parallel_threads_per_cpu integer 2
>recovery_parallelism integer 0
>
>Although the tables were created with the PARALLEL option (probably a
>horrible mistake).
>
>Anyway what is really troubling is now we get this ORA-12805 error in a
>report query that runs nightly. Would the initial failure have triggered
>this cascade of errors?

If all your tables have been created with parallel and you have multiple statements open, and you only allow for 5 query slaves? Very much looks like it.
Just
alter table ... noparallel
and you should be back to normal.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Dec 22 2004 - 11:43:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US