Microsoft Office 2007 Enterprise Oracle9i on Windo

Oracle under Windows 2000 Efficiency Optimization to think about disk I / O, CPU, network subsystem, the memory of quite a few subsystems, this highlights the Oracle within the Windows 2000 surroundings, memory adjustment.

one, optimize disk configuration
Oracle is really a disk I / O intensive programs, make certain you correctly configure the disk and file technique:

generate data files on the disk prior to the very first
run Disk Defragmenter to defragment the challenging disk for protection, must shut the open instance from the information file, and stop the services. If you have sufficient disk area to create a continuous information file, you can actually very easily generate the data file to avoid fragmentation.


don't use disk compression
Oracle data file does not assistance disk compression.


Do not use disk encryption encrypted disk compression the same as adding a layer of reduced processing velocity for the disk study and create. Should you be concerned that their information might possibly leak to use dbms_obfuscation selectively package deal and label security delicate components of the encrypted information.

Don't use more than 70% for the remaining disk space
temporary information storage system of disk space as Disk Defragmenter and intermediate information storage.

select hardware RAID using the RAID
more than software RAID;
with hardware RAID controller;
log file not about the RAID five volume,Microsoft Office 2007 Enterprise, simply because high-performance RAID five read and write efficiency poor.
the log files and archive logs and control files and information on separate disk file control technique.

separate pages to the swap file across several disks bodily volumes
at least two disks to produce two page document. You can actually develop a four web page document and benefit in efficiency, to make certain that all web page file dimensions of physical memory and at least twice.


2nd, optimizing CPU usage and configuration

cancel the screen saver screen saver
learned a lot of CPU sources, but also provides the database server is meaningless and ineffective,Microsoft Office 2007, in particular Prohibition 3GL display screen saver, display saver when you have to use to use

the program is configured to run the application server
control panel comparable to Oracle's support against the person inside the graphical person interface to begin a clumsy method.

surveillance method within the consumption on the hardware interrupt CPU interrupt and time consuming
hardware should really be avoided. This hardware is normally less expensive simply because it can be the work load the CPU, the CPU performance to deal with sophisticated peripheral hardware, normally need to pay out attention:
1, help the bus manage card
two, assistance the DMA doesn't help PIO disk controller
use Efficiency Observe object tracking processor% Interrupt Time counter values, and this counters the baseline and standards, and then keep track of the challenge.
3, enabling to keep away from the interruption is to use hardware RAID controller instead of Windows 2000 support software RAID.

kept to a minimum safety audit information

a dedicated server running Oracle
Oracle memory consumption is significant, do not carry out the subsequent capabilities on the system operating Oracle Database:
one, main or backup domain controller (Windows 2000 domain controller underneath all recognized)
two, file server
3, the print server
4, the remote entry server
5,Microsoft Office Enterprise 2007, router, proxy or firewall
Don't use fancy wallpaper (if working with, to try to minimize the wallpaper file dimension)


from non-essential companies must disable the technique of non-essential companies, if from time to time call for certain solutions can set the startup kind to br> two, stop the License Logging Services services it except if you've special specifications;
three,Windows 7 Pro, really should not use the DHCP support, and also to prohibit it;
four,Office 2010 Activation, don't immediately commence the program you do not have to have;
check menu
3rd, optimize network configuration, network configuration
performance tuning can be a very very important component, and it truly is quick to hide overall performance bottlenecks.

configure network card to make use of the fastest speed and valid product for the automated detection
that most of the default installation will be the NIC, if it really is optional to create changes for velocity.

remove needless network protocols
leaving only TCP / IP protocol.


optimize network protocol binding purchase on the set on each and every card master agreement, generally TCP / IP, the protocol record on the top.

optimized for that Oracle file sharing
prohibit or ideally will need to be banned file sharing to reduce safety breaches and network site visitors, but if you ever must use file and print sharing, then every network adapter configuration method The