Oracle performance optimization on 1th/2 page _oracle

The Oracle tutorial you are looking at is: Oracle performance optimization.

Linux Journal published an article that optimizes the Oracle database and feels very useful. Briefly introduce its summary and everyone to share Linux in enterprise database applications.

Currently, HP,COMPAQ,DELL,IBM and Oracle are speeding up their embrace of Linux, an open-source operating system. Last year, the sales of Linux servers accounted for about 13.5% of the 13.7%,ibm of Compaq's 30%,dell, according to EWeek. And IBM's 2001 investment in Linux is 1 billion. Intel's latest 64-bit Itanium CPU supports only four operating systems: Windows, Linux, AIX, and HP-UX. Nor should we forget that Oracle's 9i database Linux version is one months ahead of the Windows version.

Although Linux can run on servers from IBM s/390 to Sun SPARC architectures, for most people, Intel is still the most-run platform for Linux. This article is about the way to improve Oracle's performance by 1000% with simple performance tuning.

The test environment used in this article is a Compaq 4 cpu,512 MB, 8 7200 RPM SCSI Disk server, and then tested on almost the same single CPU Athlon system, like memory, but only one 7200 rpm of the Ultra I DE disk. Although the final results are not the same as the percentages obtained, the observed performance increases are consistent.

For simplicity's sake, our test environment uses the TPC benchmark, which is widely used for OLTP load tests. The Quest company has a tool called Benchmark Factory that makes testing work as simple as sending e-mail.

Below we will look at the results of the test through DB adjustment and OS adjustment.

DB1 initialization parameters are generally uncommon, and to illustrate the problem, we use these parameters as benchmarks.

Db1:initial Database
Database Block Size 2K
SGA Buffer Cache 64M
SGA Shared Pool 64M
SGA Redo Cache 4M
Redo Log Files 4M
Tablespaces Dictionary
TPC Results Load Time (Seconds) 49.41
Transactions/second 8.152

Obviously need to increase the size of the SGA, we look at the results of DB2:

Db2:cache & Pool
Database Block Size 2K
SGA Buffer Cache 128M
SGA Shared Pool 128M
SGA Redo Cache 4M
Redo Log Files 4M
Tablespaces Dictionary
TPC Results Load Time (Seconds) 48.57
Transactions/second 9.147

Current 1/2 page 12 Next read the full text