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

Thread: Oracle processes taking mucho memory

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Oracle processes taking mucho memory

    Hi,

    We have recently upgraded from 8.1.7.4 to 9.2.0.5

    We are getting into memory problems even though we have 8GB.
    It seems that the Oracle processes are taking up to 80Mb.
    Is this to be expected?
    If not, what is the best way to reduce the amount of memory
    each process uses?

    BTW..we have about 30 instances on this dev server.

    Thanks

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    30 instances?

    Put each instance in one Desktop PC.

    Tamil

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you "Ask Tom" you'll find one instance per server as his recommendation. For example: http://asktom.oracle.com/pls/ask/f?p...:4347545437371

  4. #4
    Join Date
    Mar 2001
    Posts
    82
    Thanks,

    Makes sense to me....


    Denis

  5. #5
    Join Date
    Mar 2001
    Posts
    82
    What is the best way to go about "gathering" all the different "applications" or "Schemas" together?

    Denis

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    My 2ยข

    To see which applications could "cohabit" I think you'll need to look at:

    - will the different applications ever need to run with different versions of Oracle?
    - are some db's in archivelog mode and others not?
    - do you have the same schema name in different db's - if so what would be the impact of changing it (e.g. do you have code like "select ... from schema1.my_table ...")
    - any impact on external systems


    Realistically I wouldn't expect you to end up with only one instance, but 4-5 big ones would be better than 30 small ones. (Though Tamil's suggestion is not 100% flipant - it depends on the licensing impact - per CPU ouch!).

    When(?) you do merge, you might want to have a tablespace per application so that backup/restore/recovery could maintain the same level of independance as now.

    Traditionally exp/imp was the way to implement this . . . it seems to me that TRANSPORTABLE TABLESPACES would have some place in the operation.

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Let me add to that whether the different application are running under CBO or RBO, and whether they have many different init parameters. Based on this some re-tuning may be required.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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