Re: Parallel Query Server died

2003-06-03 Thread Mladen Gogala
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 --

Re: Parallel Query Server died

2003-06-03 Thread shuan.tay\(PCI\)
- 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

RE: Parallel Query Server died

2003-06-02 Thread Govind.Arumugam
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

Re: Parallel Query Server died

2003-06-02 Thread shuan.tay\(PCI\)
- 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

RE: Parallel Query Server died

2003-06-01 Thread Jamadagni, Rajendra
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

Re: Parallel Query Server died

2003-06-01 Thread Mogens N?rgaard
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

Re: Parallel Query Server died

2003-05-31 Thread Mladen Gogala
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

Re: Parallel Query Server died

2003-05-31 Thread helpdesk . hcl
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

Re: Parallel Query Server died

2003-05-31 Thread Rajesh . Rao
by: Subject: Re: Parallel Query Server died [EMAIL PROTECTED] om

RE: Parallel Query Server died

2003-05-31 Thread Rajesh Dayal
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

Parallel Query Server died

2003-05-30 Thread shuan.tay\(PCI\)
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.

Re: Parallel Query Server died

2003-05-30 Thread helpdesk . hcl
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 --

Re: Parallel Query Server died

2003-05-30 Thread Vladimir Barac
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

Re: Parallel Query Server died

2003-05-30 Thread shuan.tay\(PCI\)
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

Re: Parallel Query Server died

2003-05-30 Thread Joe Testa
:[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

RE: Parallel Query Server died

2003-05-30 Thread Thater, William
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