#718. While you were on vacation, several new applications were added to a database that you manage. Another DBA did his best to tune the database while you were gone, and increased the buffer cache hit ratio from 85 percent to 94 percent after increasing the size of the DB_CACHE_SIZE from 96 MB to 128 MB. As a result, the size of the SGA is now 256 MB, which is the maximum amount of memory that can be allocated for this database. You have set the init.ora parameter SGA_MAX_SIZE = 256 MB to meet that restriction. In addition, the init.ora parameter SHARED_POOL_SIZE is set to 48 MB. Your problem is that the OLTP applications are not performing with their normal 3- second response time as they did in the past. What can you do to try to get the response time for OLTP applications to less than three seconds?
gen. 0.036
Forum
Master braindump