Oracle overview of oracle database performance tuning

sla :service level agreements

problems:session,cursor,relational design

tuning steps in devlepment: tune design,application,memory,i/o,contention,os

baseline

steps for a production db: define the problem,examine os/oracle para,consider common performance errors,build a conceptual model,implement and measure the change,check that the booleneck has been resolved

tuning method:alert log and trace files for errors->para file-> mem,i/o,cpu->indetify sql statement

tuning response time: cpu time ,wait time

trade-offs of performance & safety