Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8i Performance Tuning: Tuning the Shared Pool and Buffer Cache |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 4 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Database administrators, network administrators |
| Prerequisites |
| Completion of the E&A Oracle Introduction, Oracle8i Database Administration, and Oracle8i Backup and Recovery Curricula |
| Course Aim |
| Explain how to tune and configure the key areas of memory and avoid memory contention |
| Learning Objectives |
| Describe how to size and tune the library cache. Describe how to configure the large pool and tune the data dictionary cache. Manage the multiple buffer cache. Avoid latches and free list contention. |
| Topics Covered |
| The library cache - Tuning issues - Sizing the library cache UGA and session memory - The data dictionary cache - Configuring the large pool Managing the buffer cache - Tuning the buffer cache - Hands-on: Calculating the cache hit ratio - Multiple buffer pools Avoiding contention - LRU latches - Free list contention - Hands-on: Adding free lists |