第二章 Oracle Performance Tuning 01_Performance Tuning Methodology.pdfVIP

Insert Picture Here Performance Tuning Methodology 大中华区渠道咨询部 What Does the DBA Tune? Performance tuning areas: • Application: – SQL statement performance Shared with developers – Change management • Instance tuning: – Memory – Database structure – Instance configuration • Operating system interactions: – I/O Shared with SA – Swap – Parameters 01 - 2 Copyright © 2011, Oracle. All rights reserved.