FAQ
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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: LeRoy Kemnitz
INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Search Discussions

  • DENNIS WILLIAMS at Jun 23, 2003 at 7:50 pm
    LeRoy

    Check out Metalink Note 199746.1

    Dennis Williams
    DBA, 80%OCP, 100% DBA

    Lifetouch, Inc.
    [EMAIL PROTECTED]

    -----Original Message-----
    Sent: Monday, June 23, 2003 3:00 PM
    To: Multiple recipients of list ORACLE-L

    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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: LeRoy Kemnitz
    INET: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: DENNIS WILLIAMS
    INET: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).
  • Reginald.W.Bailey_at_jpmorgan.com at Jun 23, 2003 at 8:11 pm
    You mean the size parameter was changed in 2000, not to the value 2000?
    Try increasing the LARGE_POOL_SIZE to at least 2MB or more, preferably 8MB
    or more.

    RWB

    Reginald W. Bailey
    IBM Global Services - ETS SW GDSD - Database Management
    Your Friendly Neighborhood DBA
    713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)

    [EMAIL PROTECTED]

    edu To: [EMAIL PROTECTED]

    Sent by: cc:

    [EMAIL PROTECTED] Subject: ora-4030 out of memory error

    ity.com

    06/23/2003

    02:59 PM

    Please respond

    to ORACLE-L

    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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: LeRoy Kemnitz
    INET: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).

    --
    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
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: [EMAIL PROTECTED] (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).
  • Shaibal Talukder at Jun 23, 2003 at 8:28 pm
    LeRoy,

    You did not say which version of Oracle. Anyway in 8.1.6 there is a bug
    1337858. If that is not the case
    check NOTE:19836.1 on metalink.

    Shaibal Talukder
    Discover Financial Services
    Oracle Engineering
    [EMAIL PROTECTED]

    Work Phone :(224) 405 1140
    Cell Phone :(513) 850 3721

    From: LeRoy Kemnitz <[EMAIL PROTECTED]>
    Reply-To: [EMAIL PROTECTED]
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    Subject: ora-4030 out of memory error
    Date: Mon, 23 Jun 2003 11:59:53 -0800
    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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: LeRoy Kemnitz
    INET: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).

    STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
    http://join.msn.com/?page=features/junkmail

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Shaibal Talukder
    INET: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).
  • Whittle Jerome Contr NCI at Jun 23, 2003 at 8:34 pm
    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
  • LeRoy Kemnitz at Jun 23, 2003 at 8:41 pm
    Yes, the parm was changed in 2000.

    pen_cursors = 300
    max_enabled_roles = 30
    db_block_buffers = 45000
    buffer_pool_keep=(buffers:5200 lru_latches:2)
    shared_pool_size = 83886080
    # shared_pool_reserved_size = 7M
    large_pool_size = 6291456
    java_pool_size = 32K
    # java_pool_size = 53886080

    These are the current values. I am new so there are no dumb suggestions.

    [EMAIL PROTECTED] wrote:
    You mean the size parameter was changed in 2000, not to the value 2000?
    Try increasing the LARGE_POOL_SIZE to at least 2MB or more, preferably 8MB
    or more.

    RWB
    ============================================================================================================

    Reginald W. Bailey
    IBM Global Services - ETS SW GDSD - Database Management
    Your Friendly Neighborhood DBA
    713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
    ============================================================================================================


    [EMAIL PROTECTED]
    edu To: [EMAIL PROTECTED]
    Sent by: cc:
    [EMAIL PROTECTED] Subject: ora-4030 out of memory error
    ity.com


    06/23/2003
    02:59 PM
    Please respond
    to ORACLE-L



    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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: LeRoy Kemnitz
    INET: [EMAIL PROTECTED]
    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: [EMAIL PROTECTED] (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).

    --
    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
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: [EMAIL PROTECTED] (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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: LeRoy Kemnitz
    INET: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).
  • LeRoy Kemnitz at Jun 23, 2003 at 8:53 pm
    I am running 8.1.7.3 oracle on AIX 4.3.3.

    Will take a look.

    Thanks,

    L.

    Shaibal Talukder wrote:
    LeRoy,

    You did not say which version of Oracle. Anyway in 8.1.6 there is a bug
    1337858. If that is not the case
    check NOTE:19836.1 on metalink.

    Shaibal Talukder
    Discover Financial Services
    Oracle Engineering
    [EMAIL PROTECTED]
    Work Phone :(224) 405 1140
    Cell Phone :(513) 850 3721
    From: LeRoy Kemnitz <[EMAIL PROTECTED]>
    Reply-To: [EMAIL PROTECTED]
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    Subject: ora-4030 out of memory error
    Date: Mon, 23 Jun 2003 11:59:53 -0800

    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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: LeRoy Kemnitz
    INET: [EMAIL PROTECTED]
    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: [EMAIL PROTECTED] (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).
    _________________________________________________________________
    STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
    http://join.msn.com/?page=features/junkmail

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Shaibal Talukder
    INET: [EMAIL PROTECTED]
    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: [EMAIL PROTECTED] (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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: LeRoy Kemnitz
    INET: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).
  • Manoj Kumar Jha at Jun 24, 2003 at 5:11 am
    PGA grows by using the malloc() or sbrk() system
    calls to extend the heap data segment for process. The new operating system
    vertual memory is then added to the PGA heap as a new extent. These extents are
    only a few kilobytes in size, and Oracle may allocate thousands of them if
    necessary.
    There are, however, operating system limits on the
    growth of the heap data segment of a process. In most cases the default limit is
    set by an OS kernel parameter(MAXDSIZ). In some cases the default can be
    changewd on a per-process basis. There is also system-wide limit on the total
    virtual memory size of all processes. That limit is related to the amount of
    swap space available. If either of these limit is exceeded, then the Orcale
    process concerned will return an ORA-4030 error.
    This error is only rarely dua to the per-process
    resource limit, and normally indicates a shortage of swap spce. To diagnose the
    problem use the OS facility to report swap space usage. On some OS Oracle
    includes a small utility called maxmem which can be used to check the maximum
    heap data segment size that a process can allocate, and which which limit is
    being hit first.
    If the problem is shortage of swap space, and if
    paging activity is moderate or heavy, then attempt to reduce the system-wide
    virtual memory usage. either by reducing the process count or by reducing the
    per-process memory usage. Otherwise, if paging activity is light or nill, you
    should increase the swap space or if OS supports it, enable the the use of
    virtual or pseudo swap space.



    Original Message -----
    From:
    Whittle Jerome Contr NCI
    To: Multiple recipients of list ORACLE-L

    Sent: Tuesday, June 24, 2003 2:30
    AM
    Subject: 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 23, '03 at 7:49p
activeJun 24, '03 at 5:11a
posts8
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase