oracle数据库系统健康检查及优化

Oracle Database Health Examination And Optimization

以某国有公司的一个数据库子系统的健康检查与优化为例,讨论了如何在大数据情况下对oracle数据库系统性能进行健康分析并调整优化。操作系统上可以从cpu,I/O,磁盘多路径访问方面检查优化。Oracle数据库系统上可以从数据库应用类型、错误日志、数据库负载和SQL语句等方面检查优化。

Through an Electricity MDS Subsystem,the article discusses how to perform health examination on Oracle database and tune the database performance.The operating system can be further optimized in terms of CPU,I/O,Mutiple-Path Disk etc.As to the Oracle database system,we can approach the issue from several aspects such as changing the types of database application,checking error logs,analysing database loading and sql etc.