3-1 Overview of tunning
what does the dba tune?
performance tuning areas:
1、Application:
1、Application:
SQL statement performance
change management
change management
shared with developers
2、Instance tuning:
Memory
Database structure
Instance configuration
Memory
Database structure
Instance configuration
3、Operation system interactions:
I/O
swap
parameters
I/O
swap
parameters
shared with SA
Tuning Questions
who tunes?
Application designers
Application developers
Database administrators
system administrators
what to tune?
how much tuning is required?
how much tuning is required?
常见性能问题
1、反复连接session
2.bad cursor，硬解析过多
3、范式越强，冗余越少，join查询可能就越多，性能越差；
权衡冗余和查询性能
1、反复连接session
2.bad cursor，硬解析过多
3、范式越强，冗余越少，join查询可能就越多，性能越差；
权衡冗余和查询性能
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27573546/viewspace-756488/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
OraDebug
下一篇：
3-2Tunning Tools
请登录后发表评论
登录
全部评论
