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

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

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 :D
Can u share the procedure on how to ASMM

http://www.google.com/search?q=oracle+asmm

Quote:

---

Originally Posted by yxez

Thanks for your responses :D
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

seriously, RTFM - all your questions are answered there

Quote:

---

Originally Posted by graham_o

I think there's been an acronym mix up. ASMM is Automatic Shared Memory Management. ASM is as you rightly say Automatic Storage Management.

---

as opposed to ASSM, of course!

to Jeff:

you post because you have to?