Re: Oracle8 on NT......Slow

From: <tim.mcconechy_at_runtime.dk>
Date: Wed, 07 Apr 1999 08:44:59 GMT
Message-ID: <7ef5ua$kl6$1@nnrp1.dejanews.com>

Hi...I had a similar slowness problem and I took a few steps...

1. Create the database so that the control files and redo logs are, duplicated on several disks other than the winnt disk: for example:control_files = ("D:\orant\database\ctl1TST.ora",
   "E:\orant\database\ctl2TST.ora","D:\orant\database\ctl2TST.ora",
   "E:\orant\database\ctl1TST.ora")
   
2. PRe_PAGE The sga.
3. Change some OS settings: · Optimize for network throughput. This setting instructs NT to allocate resources such that they are more available and useable to application processes that execute locally on the server. This setting defaults to "Optimize for file sharing", and modifying this setting will typically generate a performance improvement of 5-10% in the ORACLE instance. Note that this setting requires a reboot before it takes effect.

This setting can be found in the following location:

  START -> Settings -> Control Panel -> Network -> Services -> Server Properties -> Maximize throughput for network applications. · Minimize foreground boost. This setting allows NT Servers that perform additional duties as user workstations to allocate more resources to interactive sessions that are logged into the console, and defaults to 50%. Assuming this box is a dedicated database server, then this setting should be set such that interactive logins are not given priorities higher than the ORACLE services. Due to NT's architecture, certain administrative tasks may require console login, and it is undesirable for the database end-users to experience a performance degradation each time an interactive login occurs. This setting essentially minimizes a 5-10% degradation during interactive login sessions. Note that this setting requires a reboot before it takes effect. This setting can be found in the following location:

     START -> Settings -> Control Panel -> System -> Performance ->
     Foreground boost = none.

· Disk format. NT allows disk to be formatted as FAT partitions, NTFS partitions, or to remain unformatted (ie. raw disk). FAT is typically not used due to it's age and less robust features. NTFS is typically the default choice, although the choice of raw disk holds certain performance gains and manageability losses. An ORACLE instance can use raw disk on NT for database files, and the typical performance increase is approximately 15% (plus or minus 5%). However, raw disk under NT requires extremely careful space management and a detailed knowledge of disk level attributes (such as number and size of cylinders, etc.), and these tasks become even more complicated if the physical disks are contained in a disk array. Also, backups can become much more difficult to perform correctly and verify, often requiring specialized utilities. Given that disk drives are becoming more and more inexpensive, and that simply adding disk can provide greater than a 15% performance improvement in disk throughput and workload capacity, the author's opinion is that raw disk on NT should be avoided in favor of easier to manage NTFS formatting.

4) My Virtual Memory is 1 GB!

I noticed a huge difference with these settings.

Here is my Init.ora file for your reference:

db_name = TST
db_files = 1020
control_files = ("D:\orant\database\ctl1TST.ora",
"E:\orant\database\ctl2TST.ora","D:\orant\database\ctl2TST.ora",
"E:\orant\database\ctl1TST.ora")

db_file_multiblock_read_count = 32
db_block_buffers = 6400
shared_pool_size = 9000000
log_checkpoint_interval = 8000
processes = 40
dml_locks = 500
log_buffer = 163840
sequence_cache_entries = 100
sequence_cache_hash_buckets = 75
#audit_trail = true
#timed_statistics = true
background_dump_dest = D:\orant\rdbms80\trace user_dump_dest = D:\orant\rdbms80\trace db_block_size =4096
compatible = 8.0.5.0.0
sort_area_size = 65536
log_checkpoint_timeout = 0
remote_login_passwordfile = exclusive
max_dump_file_size = 10240
PRE_PAGE_SGA = true

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 03:44:59 CDT