Thanks Mogens,
It works great with no parallelism set.
But when parallelism is set to DEFAULT it fails
(intermittently). The tables are imported from a
Non-Rac production environment.
Found a note on Metalink last night which says DEFAULT
is calculated as : CPU_COUNT*PARALLEL_THREADS_PER_CPU
and
Shouldn't happen, but one would have to question the use of PQ on such a
small table anyway. You may be hitting some lower boundary condition that
the developers didn't even look at because the table's so small?
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
We are on 2-Node Rac 9204/Solaris8.
We are having intermittent issues with parallel
queries (The table has only 470 records, executes
1sec otherwise):
SQL /
select count(*)from eod
*
ERROR at line 1:
ORA-12805: parallel query server died unexpectedly
Trace File has:
kxfp_send_callback
I'm not sure I understand. Is this a query that should access a 470
record table and which uses Parallel Query in a RAC environment? And
when it works, it executes in less than a second?
If yes, have you tested this query without Parallel Query?
If no, where did I misunderstand you?
Best
