Title: RE: ora-4030 out of memory error

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

Reply via email to