Optimize Oracle9i performance in Windows 2000 (1)

I. Optimized disk configuration
Oracle is a disk I/O-intensive application. Make sure that you configure the disk and file system properly:
Run the disk fragment program before creating a data file on the disk.
To securely organize disk fragments, You need to disable the instance that opens the data file and stop the service. If you have enough continuous disk space to create data files, you can easily avoid data file fragments.
Do not use disk compression
Oracle data files do not support disk compression.
Do not use disk encryption
Encryption adds a processing layer like disk compression to reduce disk read/write speeds. If you are worried that your data may be leaked, use the dbms_obfuscation package and label security to selectively Encrypt sensitive data.
Do not use more than 70% disk space
The remaining disk space is used to store temporary system data and intermediate data as the disk fragment program.
Use RAID
Select hardware RAID exceeding software RAID;
With hardware RAID Controller;
Do not place log files on RAID 5 because RAID 5 has high read performance and poor write performance.
Place log files and archive logs in the disk control system that is separated from control files and data files.
Detach Page Swap files to multiple Disk Physical volumes
Create two page files across at least two disks. You can create four page files and benefit from the performance. Make sure that the total size of all page files is at least twice the physical memory size.
Ii. Optimize CPU usage and Configuration
Cancel Screen Protection
Screen Protection absorbs a large amount of CPU resources and provides meaningless use for database servers. In particular, 3GL screen protection must be disabled, if you must use screen protection, use "empty screen" to reduce CPU usage.
Configure the system as an application server
On the "System" tab of the running control panel, set "performance options" to "background programs", which provides priority to applications, such as services similar to Oracle, you are opposed to starting a clumsy program on the graphic user interface.
Monitors interrupted hardware consumption in the system
Hardware that consumes CPU interruptions and time should be avoided. Generally, this hardware is cheap because it loads work into the CPU, and the CPU needs to process peripheral hardware with advanced performance. Note:
1. Nic that supports Bus Control
2. Disk controllers that support DMA instead of PIO
Use the performance monitor to track the % Interrupt Time counter value of the processor object and the baseline and standard of this counter, and then monitor the problem.
3. A hardware RAID controller is used to replace the software RAID supported by Windows 2000.
Keep minimum security audit records
Run Oracle on a dedicated server
Oracle is a large memory consumer. Do not run Oracle databases on systems that execute the following functions:
1. The primary domain or backup domain controller is called a domain controller in Windows 2000)
2. File Server
3. Print Server
4. Remote Server Access
5. Routers, proxies, or firewalls
Do not use Fancy wallpapers. If you use them, minimize the wallpaper file size)

Disable non-essential services
It is best to disable non-essential services in the system. If some service functions are required from time to time, you can set the Startup Type to "Manual". To do this, first verify the actual service requirements with the network administrator:
1. If your system does not need a printer, usually stop the service and set it to manual;
2. Stop the License Logging Service unless you have special requirements for it;
3. Do not use the DHCP service and disable it;
4. Do not start unnecessary programs automatically;
Check the content in "Start/Program/start" and delete unnecessary programs.