You will have to pay attention to how each component of the SGA performs to decide the optimal size. The Oracle...
Performance Tuning Guide for your version has details on how to do just this. Please look for this document here.
Oracle 10g does help by letting you devote a chunk of memory to the total SGA and then managing the individual components within the SGA for you. Simply set the SGA_TARGET parameter and Oracle will take care of the rest for you. As a rule of thumb, Oracle Corp. is recommending that you set SGA_TARGET to one-third of your database server's physical memory.
Dig Deeper on Oracle database design and architecture
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.