 |
Oficinas en México |
|
|||||||||
   |
||||||||
Performance Tuning of Databases and applicationsIT Consulting ServicesThe DBA is responsible for tuning the databases independently from each other in accordance with the size of the database and applications and for having solutions to remedy the parts of the system that are slowing down processing. Tuning a database server is done on multiple levels. The capacity of the server hardware and the way the operating system is configured can become limiting factors, as can the database software configuration. The way the database is physically laid out on the disk drives and the types of indexing chosen also have an effect. Finally, the way queries against the database are coded can significantly change how fast results are returned. For this reason database tuning must be taken into consideration as:• Performance Tuning Write appropriate tuning goals Apply the tuning methodology Balance performance and safety trade-offs Identify common tuning problems Log a performance Service Request with Oracle Support • Statistics and Wait Events Identify dynamic performance views useful in tuning Identify key tuning components of the alert log file Identify key tuning components of user trace files Use dynamic performance views to view statistics and wait events • Metrics, Alerts, and Baselines View metrics using the metrics history views Create metric thresholds View alerts Create metric baselines Enable adaptive thresholds • Using Statspack Install Statspack Create Statspack snapshots Generate Statspack reports Identify the major sections of the Statspack report • Using AWR Create and manage AWR snapshots Generate AWR reports Create snapshot sets and compare periods Generate ADDM reports Generate ASH reports • Reactive Tuning Use Enterprise Manager pages to identify symptoms Eliminate operating system issues • Tuning the Shared Pool Diagnose shared pool problems Size the shared pool Size the reserved area Keep objects in the shared pool • Tuning the Buffer Cache Describe the buffer cache architecture Size the buffer cache Resolve common performance issues related to the buffer cache Use common diagnostic indicators to suggest a possible solution • Automatic Shared Memory Enable Automatic Shared Memory Set auto-tuned memory parameters Set the manually tuned SGA parameters Use the SGA advisor to set SGA target • Checkpoint and Redo Tuning Diagnose checkpoint and redo issues Implement Fast Start MTTR target Monitor performance impact of Fast Start MTTR target Implement multiple database writers Tune the redo chain Size the redo log file Size the redo log buffer • Tuning I/O Diagnose database I/O issues Describe the Stripe and Mirror Everything (SAME) concept Explain the benefits of asynchronous I/O Choose appropriate I/O solutions • Tuning PGA and Temporary Space Diagnose PGA memory issues Size the PGA memory Diagnose temporary space issues Specify temporary tablespace parameters for efficient operation • Tuning Block Space Usage Tune segment space management Convert from dictionary managed tablespaces Convert to automatic segment space management Tune block space management Diagnose and correct row chaining Diagnose table fragmentation Compare characteristics of big file and small file tablespaces |
||||||||
