-
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
-
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.
-
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
-
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.
-
I think there's been an acronym mix up. ASMM is Automatic Shared Memory Management. ASM is as you rightly say Automatic Storage Management.
-
Thanks for your responses
Can u share the procedure on how to ASMM
Behind The Success And Failure Of A Man Is A Woman
-
-
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'??
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|