DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: ora-4030 - Urgent

  1. 04-02-2003, 04:58 PM #11
    badrinathn
    badrinathn is offline Advisor
    Join Date
    Jan 2001
    Posts
    642
    Thanks Pando;

    '4010 is related to PGA'.

    I am connecting from the server directly and think it makes a dedicated server connection in this case. I have a plenty of memory unused but still get this error for only one query while the others with more number of record(and so sorts) go through well.

    Will increasing the ram help or decreasing the Sort_area_size help. If decreasing sort_area_size can help then why?

    Please clarify.

    Badrinath
    There is always a better way to do the things.
    Reply With Quote Reply With Quote
  2. 04-02-2003, 11:24 PM #12
    Calvin_Qiu's Avatar
    Calvin_Qiu
    Calvin_Qiu is offline Senior Member
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Windows OS? What is the memory usage of Oracle.exe?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998
    Reply With Quote Reply With Quote
  3. 04-03-2003, 11:53 AM #13
    badrinathn
    badrinathn is offline Advisor
    Join Date
    Jan 2001
    Posts
    642
    Yes It's Windows: Oracle.exe is 572 MB.

    One question: How can the Oracle.exe be 572 while the the SGA is ~800MB.

    Badrinath
    There is always a better way to do the things.
    Reply With Quote Reply With Quote
  4. 04-03-2003, 12:25 PM #14
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I guess that part of it is paged out.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  5. 04-03-2003, 12:27 PM #15
    badrinathn
    badrinathn is offline Advisor
    Join Date
    Jan 2001
    Posts
    642
    I have 2GB of Physical memory and 4 GB of VM, even if it paged out, isn't the memory available?

    Thanks,
    Badrinath
    There is always a better way to do the things.
    Reply With Quote Reply With Quote
  6. 04-16-2003, 02:09 PM #16
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    How did you fix your problem?

    I am also getting same ORA error.

    Pl. share...

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  7. 04-16-2003, 02:36 PM #17
    badrinathn
    badrinathn is offline Advisor
    Join Date
    Jan 2001
    Posts
    642
    Sorry! I didn't post back the reply.

    I decreased the sort area size to 50M and the SGA size (as I had a lot of unused shared pool)( It's still high and will reduce it after few more testing). I also monitored the memory usage and was at time shocked to see the memory usage going as close as 2GB (the limit for oracle as I have not made any changes to the NT boot.ini file to extend the memory).

    Badrinath
    There is always a better way to do the things.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width