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
---------------------------------------------------------------------
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 Fri May 30 2003 - 07:54:39 CDT
