Re: Parallel Query Server died

From: shuan.tay\(PCI鄭祺勛\) <shuan.tay_at_pci.co.id>
Date: Sun, 01 Jun 2003 19:44:40 -0800
Message-ID: <F001.005A7D34.20030601194440@fatcity.com>

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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
> likely thing that is happening is that parallel query servers are running
out of
> stack. May be you should decrease sort/hash area size?
> On 2003.05.30 07:04 shuan.tay28PCI?????????29 wrote:
> >
> > >
> > > 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
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author:
> > > INET: helpdesk.hcl_at_bplmail.com
> >
> >
> > Dear all DBAs,
> >
> > I've already checked the solution by issuing oerr.
> > It only suggest to check the system for anomalies and reissue the
statement.
> > but, mm...what statement? the SQL statement?
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: =?utf-8?Q?shuan.tay\=28PCI=E9=84=AD=E7=A5=BA=E5=8B=9B\=29?=
> > INET: shuan.tay_at_pci.co.id
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >

>

> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net

>


> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

> San Diego, California        -- Mailing list and web hosting services


Mladen,

There's only a line in the .trc file:
"kxfpqsrls: Timed out trying to release slave 4:1 -- resignaling"

Shuan

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?utf-8?Q?shuan.tay\=28PCI=E9=84=AD=E7=A5=BA=E5=8B=9B\=29?=
  INET: shuan.tay_at_pci.co.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sun Jun 01 2003 - 22:44:40 CDT