Wednesday, August 22, 2012

stripe unit size and DB_FILE_MULTIBLOCK_READ_COUNT



Stripe-unit size
With RAID technology, data is striped across an array of physical disks. This data distribution scheme complements the way that the operating system requests data.
The granularity at which data is stored on one disk of the array before subsequent data is stored on the next disk of the array is called the stripe-unit size. The collection of stripe units, from the first disk of the array to the last disk of the array, is called a stripe.
For PCI-X and PCIe controllers, you can set the stripe-unit size of an IBM® SAS Disk Array to 16 KB, 64 KB, 256 KB, or 512 KB. You might be able to maximize the performance of your disk array by setting the stripe-unit size to a value that is slightly larger than the size of the average system I/O request. For large system I/O requests, use a stripe-unit size of 256 KB or 512KB. The recommended stripe size will be identified on the screen when you create the disk array.
For PCIe2 controllers, you can only set a stripe-unit size of 256 KB. This stripe-unit size has been selected to provide the optimum performance when used with both HDDs and SSDs.

And similar link http://ibm.co/Re9h3D


From http://communities.vmware.com/thread/293789

3. RAID array stripe unit size - This is how much data is written to one disk before having
to jump to the next disk within a single stripe. evidently performance in general follows
some sort of bell curve. We used the default 64k of our H700 RAID controller as the control
and found that setting this to 256k gave us the best overall performance gains.One would
think 1024k would be best but that was not the case. Ok, so here are some raw
percentages we pulled out of our tests using bonnie+, here we are looking at the
advantage of going with 256K stripe units:



A.2.5 Using the DB_FILE_MULTIBLOCK_READ_COUNT Parameter

When using Direct I/O or Concurrent I/O with Oracle Database 10g, the AIX file system does not perform any read-ahead on sequential scans. For this reason the DB_FILE_MULTIBLOCK_READ_COUNT value in the server parameter file should be increased when Direct I/O or Concurrent I/O is enabled on Oracle data files. The read ahead is performed by Oracle Database as specified by the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter.

Setting a large value for the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter usually yields better I/O throughput on sequential scans. On AIX, this parameter ranges from 1 to 512, but using a value higher than 16 usually does not provide additional performance gain.

Set this parameter so that its value when multiplied by the value of the DB_BLOCK_SIZE parameter produces a number larger than the LVM stripe size. Such a setting causes more disks to be used.




Tuesday, August 21, 2012

how to set user password unexpire?

Actually, we can retain the current password by " alter user  identified by values ' xxxx' " , while changing the status from expired to open.  In 11g, the hashed password can be found in SYS.USER$.


Ref:
http://stackoverflow.com/questions/1766445/oracle-how-to-set-user-password-unexpire

Saturday, August 18, 2012

How To Install VMware Player In Ubuntu 12.04

http://bit.ly/Nx46wx

Nice article, used the same patch fixed my installation of vmplayer 4.0.4


Wednesday, August 15, 2012

linux fstab

commands learned which related to UUID and label are:

Display current label

sudo e2label /dev/sda1

 

To get a list of all the UUIDs, use one of the following two commands:
sudo blkid
ls -l /dev/disk/by-uuid

More info can be found below.

AutomaticallyMountPartitions

Introduction to fstab

Understanding fstab 

Label a Linux Partition

 

 

 

Thursday, August 02, 2012

X11 over firewall


did a quick study on X11 over firewall, and find two ways to do so .
1. X11 forwarding . Need to ensure SSH server by default/configured to support X11 forwarding on various unix-like platform.
2. Open port number 6000 to our laptop (using static ip ) that running x-server. Network team has to open this port on all  servers to those laptops needs to run x-window.
The followings links may help .
http://forums.vandyke.com/showthread.php?t=322

Tested that in order to run X11 application from UNIX server to our PC, we need to open TCP port number 6000 only .
i.e. The source ip is the unix server where we invoke xclock.
The destination ip is our PC, e.g. 10.84.100.24
Port number: TCP 6000
 

"Yes, in a nut shell. If you can connect via SSH, and your SSH server on the Unix side allows X11 port forwarding, then you can tunnel the X display back to your PC. NAT does matter in this case, since you are already connected.

Be sure *not* to set your DISPLAY variable after logon to the target server, and allow SSH to do it for you."



http://www.cyberciti.biz/tips/iptables-block-remote-x-window-server-connection.html

http://www.linux-tip.net/cms/content/view/302/26/


Here is X11 forwarding setting in putty.


Similarly, using openssh SSH in cygwin, needs to export DISPALY before invoke ssh command. e.g.

$ export DISPLAY=localhost:0

liqy@MP04ISLLIQY ~
$ ssh -X -l oracle dev07

Otherwise, may encounter below error.


dev07:B.11:TESTDB:/software/oracle> xclock                                                             
connect /tmp/.X11-unix/X0: No such file or directory
X connection to 10.132.90.1:11.0 broken (explicit kill or server shutdown).


Here are two sessions logon to same server 10.132.90.1 , note that the value of DISPLAY set by X11 forwarding are different: 10.132.90.1:10.0 and  10.132.90.1:12.0