Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    46

    Unanswered: What should be the maximum Memory Allocation

    Dear Support,

    I am using oracle database 10gR2 on Windows Server R2 and in dedicated mode.

    Currently my sga is allocated as below:

    sga_max_size big integer 1G
    sga_target big integer 832M

    However, because Activity on database is increasing due to more user accessess, when I check the Task Manger Oracle Process is using at least 1,074,000

    I would therefore like to know if someone can advise me on how much memory should be the right one

    Any advice is well come

    Kind Regards
    Silas

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Memory allocation depends on many things e.g. size of db, usage of db, type of db (e.g. OLTP, warehouse, etc), number of users, hardware, server resources etc etc etc. It's (almost) impossible to determine what memory setting is the correct one without investigating (e.g. by running tuning scripts).
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    that depends on how much memory the box has and what else the box does.
    personally I don't see an advantage to SLOWLY increasing the memory allocation.
    if it's a dedicated db server then allocate 50-70% of total memory to the database.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Aug 2009
    Posts
    262
    ORAEDT11gtest> show parameter pool

    post the results

Posting Permissions

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