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

Thread: CPU and Memory Consumption by Oracle

  1. #11
    Join Date
    Oct 2001
    Posts
    13
    Yes that could be the reason. Increase the number of rollback segments.

  2. #12
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    since you are saying that Oracle.exe is taking 1.35 GB, I believe you Oracle is doing paging and swapping.

    Do you have the means to find this at the OS Level ?

    All the Parameters and Values dont look that bad to me,
    are there any other application on that NT Server that are fighting for Memory ?

    With a 300+ userbase, your DB must be a MTS configuration.
    It that the case ?


  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by patnams


    With a 300+ userbase, your DB must be a MTS configuration.
    It that the case ?


    well well it is NOT a must

  4. #14
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    But I already have rollback segments at 40.

    Nop other application is running on Prod Server only One instance of Oracle and SAP Central Instance.

    No it is not MTS config, an all 300 users doesn't interact directly with Oracle. There is only One user SAPR3 which have multiple sessions to interact with Oracle.

    --------------------------
    The Time has come ....

  5. #15
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    When I say MTS is a must, I meant at 300 Users you'd require a very large shared pool and processing capacity. Sorry about that...

    It does not matter whether you have 1 user or 300 users. When refering to performance and # of users it invariably means # of sessions.

    At 300 Sessions and with your Server Configuration, I'm sure there should be a significant difference when you switch to MTS.

    Also 40 Rollback Segments ? Assuming 4 Trans per RBS, do you really have 160 Transaction at any point of time. Anyway RBS might not be an issue in this case.

    Again, I'd go for an MTS if my userbase exceeds say 40 on a reasonably good server.

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