Microsoft Office Professional 2010 Oracle9i on Win

Oracle under Windows 2000 Overall performance Optimization to give consideration to disk I / O, CPU, network subsystem, the memory of many subsystems, this highlights the Oracle inside the Windows 2000 environment, memory adjustment.

one, optimize disk configuration
Oracle can be a disk I / O extreme purposes, ensure that you correctly configure the disk and file program:

produce data files on the disk before the first
run Disk Defragmenter to defragment the hard disk for safety, should near the open instance with the information file, and stop the service. When you have enough disk space to produce a constant data file, you possibly can effortlessly create the information file to prevent fragmentation.


don't use disk compression
Oracle data file doesn't assistance disk compression.


Do not use disk encryption encrypted disk compression the same as incorporating a layer of decreased processing speed with the disk read and compose. Should you be fearful that their data could leak to make use of dbms_obfuscation selectively bundle and label safety delicate parts in the encrypted information.

Do not use extra than 70% of your remaining disk area
short-term data storage method of disk space as Disk Defragmenter and intermediate information storage.

pick hardware RAID working with the RAID
more than software RAID;
with hardware RAID controller;
log file not about the RAID five quantity, because high-performance RAID five study and create overall performance very poor.
the log files and archive logs and control files and information on individual disk file control technique.

separate pages towards the swap file across multiple disks bodily volumes
at least two disks to develop two web page document. It is easy to generate a four web page document and advantage in overall performance, to make sure that all web page file dimension of bodily memory and at least twice.


2nd, optimizing CPU utilization and configuration

cancel the screen saver screen saver
learned a lot of CPU sources,Microsoft Office Professional 2010, but also offers the database server is meaningless and ineffective, specifically Prohibition 3GL display screen saver, screen saver if you have to use to use

the program is configured to run the application server
manage panel comparable to Oracle's service towards the user inside the graphical person interface to start a clumsy procedure.

surveillance technique inside the consumption for the hardware interrupt CPU interrupt and time consuming
hardware ought to be avoided. This hardware is normally cheaper mainly because it really is the work load the CPU, the CPU performance to deal with advanced peripheral hardware, normally must pay out interest:
1, support the bus manage card
2, support the DMA doesn't assistance PIO disk controller
use Overall performance Watch object tracking processor% Interrupt Time counter values, and this counters the baseline and requirements, after which observe the problem.
three, enabling to prevent the interruption would be to use hardware RAID controller as an alternative to Windows 2000 help software RAID.

kept to a minimal protection audit information

a committed server operating Oracle
Oracle memory consumption is huge, don't carry out the following functions in the system running Oracle Database:
1, primary or backup domain controller (Windows 2000 domain controller under all recognized)
two, file server
3, the print server
four, the remote accessibility server
five, router, proxy or firewall
Don't use fancy wallpaper (if employing, to try to decrease the wallpaper file dimension)


in opposition to non-essential companies need to disable the program of non-essential providers, if in some cases call for particular providers can set the startup sort to br> 2, quit the License Logging Support support it unless you've got special requirements;
3, must not use the DHCP services, and also to prohibit it;
four, do not automatically begin the plan you do not need;
examine menu
Third, optimize network configuration, network configuration
performance tuning is a very essential component, and it really is painless to conceal overall performance bottlenecks.

configure network card to use the quickest speed and valid design for your computerized detection
that most of the default set up is the NIC, if it's optional to make changes for pace.

eliminate needless network protocols
leaving only TCP / IP protocol.


optimize network protocol binding purchase on the set on each and every card grasp agreement, commonly TCP / IP, the protocol list from the top.

optimized for the Oracle file sharing
prohibit or ideally really should be banned file sharing to minimize protection breaches and network site visitors, but if you ever need to use file and print sharing, then each and every network adapter configuration technique The