Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  Oracle Tips by Burleson

Disk Configurations

As previously stated, a TMS RAMSan, a SCSI disk array, and an ATA disk array were utilized during tests. If this were a full disclosure benchmark, it would be necessary to divulge the manufacturers, prices, and other details about the various arrays. Since this is not a full benchmark, the important characteristics of the disk array will be provided without divulging the manufacturers since they were good enough to lend their equipment for the tests. The specifications for the various disk and SSD equipment used are as follows:

  • The Texas Memory Systems solid state disk array, a 64 Gigabyte RamSan 320 was presented as one large disk. The RamSan has no stripes, mirrors or other physical specifications other than those created by the volume creation commands presented before. The RamSan has built-in backup capabilities in case of loss of power and is built using state-of-the-art high-speed ECC memory chips.

  • The SCSI array used in initial testing consisted of 2-36 Gigabyte 10,000 RPM Seagate Cheetah disks striped at 128K.

  • The ATA array used in final testing consisted of 7-200 Gigabyte 7,200 RPM 133 disks. The disks were striped n 64K stripes.

  • The disk HBA interface cards were QlogicQLA2342 2-Gigabit fibre channel.

The output of the dmesg command show the actual system disk configurations for the first part of the test using the SCSI drives.

scsi(1): Topology - (N_Port-to-N_Port), Host Loop address 0x1
  Vendor: TMS       Model: FC65              Rev: 1.4b
 
Type:   Direct-Access                      ANSI SCSI revision: 04
Starting timer : 0 0
blk: queue f6e24e18, I/O limit 4095Mb (mask 0xffffffff)
scsi(0:0:0:0): Enabled tagged queuing, queue depth 32.
Starting timer : 0 0
  Vendor: (omitted by request)  Model: (omitted) FC RAID     Rev: 3.03
  Type:   Direct-Access                      ANSI SCSI revision: 03
Starting timer : 0 0
blk: queue f6e24c18, I/O limit 4095Mb (mask 0xffffffff)
scsi(1:0:0:0): Enabled tagged queuing, queue depth 32.
Attached scsi disk sda at scsi0, channel 0, id 0, lun 0
Attached scsi disk sdb at scsi1, channel 0, id 0, lun 0
SCSI device sda: 134217728 512-byte hdwr sectors (68719 MB)
 sda: unknown partition table
SCSI device sdb: 143360000 512-byte hdwr sectors (73400 MB)
 sdb: unknown partition table

Other than showing a different device, the listing for the ATA based disk array was identical to the listing for sdbabove.

Other than the RAMSan array, these are standard off-the-shelf components configured as they would be for use in Oracle shops worldwide. The next topic is the network configuration.


The above book excerpt is from:

Oracle Solid State Disk Tuning

High Performance Oracle tuning with RAM disk

ISBN 0-9744486-5-6  

Donald K. Burleson & Mike Ault

http://www.rampant-books.com/book_2005_1_ssd.htm

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter