972145 wrote:There is nothing like standard memory allocation. The memory allocation is recommended to be done using ASMM in 10g and using AMM in 11g. So if you are unsure about what size to pick for the parameters , let Oracle decide it for you. Using AMM , if I remember correctly, a reserved percentage(cant recall how much) is reserved by Oracle. You can get start with it and after monitoring your db for few weeks, change it to a more appropriate value.
I wanted to know what is the standard memory allocation for SGA & PGA in a normal installation of Oracle database 10g or 11g? Are the figures of 270M and 90M standard for a 10g or 11g installation using automatic memory management feature?
972145 wrote:And what you have done with the inputs given so far for both the threads? You must understand that when you are looking for the memory allocation from the o/s and all looks good it doesn't mean that it is really good from the database side too. So far, you haven't shown us any issue that you are facing except for the statement from one thread of yours that the memory is consumed close to 90(or 99%) . The best way to monitor the database, as it is a database forum, is to check the AWR/Statspack report and see if there is any thing related to any memory area reported in it and even before that, what's the performance of the database in general? If all is okay, you probably don't need to do anything.
Sorry in case you felt that these are duplicate but both are different. One deals with allocation of memory in an Oracle install and the other the best way to monitor use of memory resources. Thanks.