52ky 发表于 2022-6-16 10:36:06

Oracle优化的五个方面.pdf

Oracle 调优是一个复杂的主题。可以写一整本关于调优的书,但是为了提高 Oracle 数据库性能,每个 Oracle DBA 都应该遵循一些基本概念。
在本简介中,我们将简要介绍以下 Oracle 主题:
外部调优:我们应该记住,Oracle 不会单独运行。因此,我们将着眼于调整 Oracle 服务器以获得高性能。
Rowre-sequencing 减少磁盘 I/O:我们应该明白,Oracle 调优的最重要目标是减少 I/O。
0racle SQL调优:Oracle SQL调优是Oracle调优中最重要的领域之一,通过一些简单的SQL调优规则可以大大提高SQL语句的性能也就不足为奇了。

(Oracle tuning is a complex topic. You can write an entire book on tuning, but in order to improve Oracle database performance, every Oracle DBA should follow some basic concepts.
In this introduction, we will briefly introduce the following Oracle topics:
External tuning: we should remember that Oracle does not run alone. Therefore, we will focus on tuning the Oracle server for high performance.
Rowre sequencing reduce disk i/o: we should understand that the most important goal of Oracle tuning is to reduce i/o.
0trace SQL tuning: Oracle SQL tuning is one of the most important areas in Oracle tuning. It is not surprising that some simple SQL tuning rules can greatly improve the performance of SQL statements.)




页: [1]
查看完整版本: Oracle优化的五个方面.pdf