Self Tuning of Oracle Database Using SQL Scripts
The Oracle professionals or DBA’s should know how to
accurately predict the high-water mark of RAM demands for
their database, and fully allocate the RAM, reserving only
enough to accommodate spikes in user connections. For an
Oracle server, in this paper the goal is to keep all the RAM
memory demands of the database and database connections
beneath the amount of physical RAM memory. In an Oracle
environment, we can accurately control the amount of RAM
memory that is used by the database instance System Global
Area (SGA). This is because the Oracle database
administrator can issue alter system command to change the
RAM memory areas, and can grow and shrink the RAM
memory areas on as needed basis.
Keywords: SGA, PGA, DBWn, LGWR, CKPT, SMON
Download Full-Text