tuning memory allocation
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: tuning memory allocation

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    tuning memory allocation

    Hi Friends,

    I have read books about tuning memory but I already forgot
    about it because I was not able to apply it in real world. Now,
    I have just installed a new 10gR2 DB for production and I only use
    the default installation. Our server has 4gb memory and I have just
    allocated 300Mb for the shared_pool_size. We will start the prod
    kick-off next week. Although I didnt mind to tune other parameters
    because I know the initial default install can handle our 100-user
    application which I think is not so complex one.

    My question is how do I know if the 300M shared_pool I allocated
    is enough for the 100 users? What dynamic data dictionary will I
    select to show how much memory is being used by each user out
    of the 300M I alloted?


    Thanks a lot
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Jan 2007
    Posts
    14
    configure automatic shared memory management (ASM) and let oracle decide for you as the database workload changes. By configuring ASM, you will not need to care for these parameters as they will be configured automatically: shared_pool_size, large_pool_size, java_pool_size and db_cache_size. You can either set these with minimum values or not configure them at all. You will need to set the sga_target to a value equal to or less than your sga.

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks dear I havent tried this ASM thing yet, I thought it is a disk storage management for RAC or (asynchronous storage management)
    It this ASM already avaible in 8i and 9i?

    Thanks
    Behind The Success And Failure Of A Man Is A Woman

  4. #4
    Join Date
    Jan 2007
    Posts
    14
    Sorry, I don't mean ASM for storage but rather automatic shared memory management. It is only available in 10g and since you have installed 10g R2 you should be able to use it.

  5. #5
    Join Date
    Apr 2006
    Posts
    50
    I think there's been an acronym mix up. ASMM is Automatic Shared Memory Management. ASM is as you rightly say Automatic Storage Management.

  6. #6
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks for your responses
    Can u share the procedure on how to ASMM
    Behind The Success And Failure Of A Man Is A Woman

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331

  8. #8
    Join Date
    Apr 2006
    Posts
    50
    Quote Originally Posted by yxez
    Thanks for your responses
    Can u share the procedure on how to ASMM
    Come ON! Surely you can do a little of the work yourself! How hard is it to search for 'Oracle and ASMM'??

  9. #9
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks dear...I read the post....it says use target and
    set autotune pool to zero. How do I know which of them is autotuned?
    Does it mean all the parameter with "_pool" in it? Or all the parameters available in the db.

    Thanks
    Behind The Success And Failure Of A Man Is A Woman

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    seriously, RTFM - all your questions are answered there

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