Shuan, this sounds like a problem for support. Are you using I/O slaves?
Mladen,
There's only a line in the .trc file:
kxfpqsrls: Timed out trying to release slave 4:1 -- resignaling
Shuan
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 02, 2003 7:39 PM
Shuan, this sounds like a problem for support. Are you using I/O slaves?
Mladen,
There's only a line in the .trc file:
kxfpqsrls: Timed out trying to
turday, May 31, 2003 2:50 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Parallel Query Server
died
After long time ..
LOL .
;-)
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Vladimir BaracS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 7:54 PM
Look for the files named somehing like ora_p00*.trc in your
BACKGROUND_DUMP_DEST
directory. If the errors are ora-0600 or ora-7445, contact oracle support.
The most
Funeral at 8pm EST, movieat11pm EST on TNT
...
Raj
-Original Message-From: Rajesh Dayal
[mailto:[EMAIL PROTECTED]Sent: Saturday, May 31, 2003 2:50
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Parallel Query Server died
After long time ..
LOL
Message-
From: Rajesh Dayal[mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 31, 2003 2:50AM
To: Multiple recipients of list ORACLE-L
Subject: RE:Parallel Query Server died
After long time ..
LOL
.;-)
-Original
Look for the files named somehing like ora_p00*.trc in your BACKGROUND_DUMP_DEST
directory. If the errors are ora-0600 or ora-7445, contact oracle support. The most
likely thing that is happening is that parallel query servers are running out of
stack. May be you should decrease sort/hash area
yes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
by: Subject: Re: Parallel Query Server died
[EMAIL PROTECTED]
om
After
long time ..
LOL .
;-)
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Vladimir
BaracSent: Friday, May 30, 2003 2:35 PMTo: Multiple
recipients of list ORACLE-LSubject: Re: Parallel Query Server
died
Kool, now some cyber funeral
Dear all DBAs,
What should i check for this error?
"ORA-12805: parallel query server died
unexpectedly"
The SQL statement was runningwell
before.
There's nothing in the alert log about this
error.
I'm using Oracle 8.1.6 on Redhat 7.2.
Thanks and have a nice
day.
hai
Cause:The PMON process is cleaning up the process because a parallel query
server terminated unexpectedly.
Action:Check for operating system errors and retry the statement. If this
problem persists, contact customer support.
may not be the 100% solution please check
manjunath
--
Kool, now some cyber funeral will take
place...
- Original Message -
From:
shuan.tay(PCI¾G¸R³Ô)
To: Multiple recipients of list ORACLE-L
Sent: Friday, May 30, 2003 11:19
Subject: Parallel Query Server died
Dear all DBAs,
What should i check for this error
hai
Cause:The PMON process is cleaning up the process because a parallel query
server terminated unexpectedly.
Action:Check for operating system errors and retry the statement. If this
problem persists, contact customer support.
may not be the 100% solution please check
manjunath
:[EMAIL PROTECTED]
*Sent:* Friday, May 30, 2003 11:19
*Subject:* Parallel Query Server died
Dear all DBAs,
What should i check for this error?
ORA-12805: parallel query server died unexpectedly
The SQL statement was running well before.
There's nothing in the alert log
Joe Testa scribbled on the wall in glitter crayon:
hahaha, that parallel query server was my friend, we knew each other
many cpu cycles, he helped after the loss of another PQS, number 5.
damn, i love this list.;-)
--
Bill Shrek Thater Oracle DBA
[EMAIL
16 matches
Mail list logo