Oracle memory problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle memory problem

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Oracle memory problem

    Hi,

    All of a sudden we are observing that the Oracle.exe is consuming a lot of memory (150MB) in our server (which holds 256mb Rram). As a result our EAI tool application keeps hanging very frequently and this has now become a major problem. How to clean the table space and how can we free more memory?

    Thanks in advance

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Has there been any changes to the SGA parameters for the DB or is there a sudden increase in the number of users or the the size of the queries they are executing?

    256Mb seems small to be running both Oracle and an EAI tool on the same box.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Rebuild Indexes and other database mantainence activities.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi

    By the way what is EAI, is it Enterprise Application Integrator from IPLANET ??

    Amar
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Jul 2000
    Posts
    119
    Is this (EAI) a SIEBEL specific tool ?
    OCP 8.0, 8i, 9i

  6. #6
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Re: Oracle memory problem

    Originally posted by lavanya_s How to clean the table space and how can we free more memory?
    What do you mean by clean the table space ????
    Best wishes!
    Dmitri

  7. #7
    Join Date
    Dec 2002
    Location
    India & Australia
    Posts
    68
    The cleaning of tablespace is not at all the criteria, remedy is either extending the space in the datafile allocation or monitor the transaction level and moreover the regularised EAI which is consuming 150MB is small amount considering the application size,......understandable. So it is your prerogative to enhance the SGA size since your application is growing.

    VAST

Posting Permissions

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


Click Here to Expand Forum to Full Width