DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Need Help ORA-4030

  1. 08-13-2002, 04:57 PM #1
    puneet
    puneet is offline Member
    Join Date
    Nov 1999
    Posts
    226
    Hi

    I am getting ORA-4030 error whenever I am trying to run a BIG Sql using a lot of BITMAP indexes . I have tried to reduce
    SGA, shared_pool and sort_area_size as "ADVISED" by some of people I know , But I still keep getting this error.
    One of the people have told me to make user_limit of memory on OS (NT) greater or unlimited .

    Hwo do I make it , What parameter on NT can I touch to make the user_process memory allocation greater ro unlimited .

    My SGA now is 357MB , Sort_area_size=1MB .

    Please advise
    Reply With Quote Reply With Quote
  2. 08-14-2002, 08:26 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    How much physical RAM do you have on the box? Are you running dedicated servers or MTS? How many sessions are connected? Are there any subsequent errors?
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 08-14-2002, 01:30 PM #3
    puneet
    puneet is offline Member
    Join Date
    Nov 1999
    Posts
    226
    Thanks for reply

    Its is an NT system , 1GB of Ram and configured for 150 users . Only 10 users login and run reports . They never have a problem with other reports but they have one "BIG" SQL that selects everything from big tables has lots of HASH JOINS and gives this error . It is an application and so I cannot change the code .

    Please advise on this

    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