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