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