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.