Hello,
In an Oralce 10.2 R2 (10.2.03) database on a Solaris 10 system we are randomly getting ORA-12805 errors (ORA-12805: parallel query server died unexpectedly). We are not using RAC. Also, on both the tablespaces and effected tables the Parallel option is not enabled.
Corresponding /udump trace files being generated that contain messages as shown below:
What can you recommend?
Thanks,
TG
In an Oralce 10.2 R2 (10.2.03) database on a Solaris 10 system we are randomly getting ORA-12805 errors (ORA-12805: parallel query server died unexpectedly). We are not using RAC. Also, on both the tablespaces and effected tables the Parallel option is not enabled.
Corresponding /udump trace files being generated that contain messages as shown below:
Code:
SERVICE NAME: (SYS$USERS) 2007-04-02 12:04:34.330
SESSION ID: (388.6351) 2007-04-02 12:04:34.330
kxfpgidr
Time out waiting for slave Join-Ack: passes:150 waits:150 csrret:3 sleep
time:200 timeouts:150 ghostposts 0
start: 18960889658 end: 1896391150 diff:301492 ksl:301492 avg_ksl:2009
old,new # of posts = 6,5
*** 2007-04-02 12:04:34:331
KSTDUMP: In-memory trace dump
TIME(usecs):SEQ ...
<<< 5 megabytes of memory dump follow>>>What can you recommend?
Thanks,
TG
