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
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
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.
We all knew him from a long time ago when he used to help out others in
doing large queries and sometimes would just hang around after
completing his work for
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
15 matches
Mail list logo
