本文介绍了数据库性能调优的关键步骤，包括识别问题所在、检查操作系统与Oracle参数设置、建立概念模型等，并探讨了如何衡量调优效果及解决瓶颈的方法。此外，还讨论了性能与安全性之间的权衡。
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
扫一扫
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
