RE: ora-4030 out of memory error

From: Whittle Jerome Contr NCI <Jerome.Whittle_at_scott.af.mil>
Date: Mon, 23 Jun 2003 13:34:29 -0700
Message-ID: <F001.005B8021.20030623130007@fatcity.com>

LeRoy,

Post the query to the list. Just maybe it could tuned or give us an idea of what's going on.

Jerry Whittle

ASIFICS DBA NCI Information Systems Inc.

[EMAIL PROTECTED] 618-622-4145

-----Original Message-----

From: LeRoy Kemnitz [SMTP:[EMAIL PROTECTED]

All -

I have a user receiving this error on several different Unix boxes with

the same query. Oracle says to increase the size limit which was done

in 2000. The sort are size parm is set to 10485760. Any suggestions??

LeRoy Received on Mon Jun 23 2003 - 15:34:29 CDT