Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Storage Array Stripe Size, ZFS Recordsize, Oracle Block Size

Avatar of G-N
G-NFlag for Switzerland asked on
Unix OSOracle DatabaseStorage
10 Comments1 Solution1697 ViewsLast Modified:
Good Afternoon Everyone,
I am trying to determine the best way forward to provisioning a Sun T5240 Server running Guest LDoms, Sun StorageTek 6140 Array and Oracle 10.2.0.4.
Background: We will commission new LDOM server environments that will host Oracle 10g Database Instances – the current DB block_size set for separate individual databases is 8K and 16K
We will use the StorageTek 6140 array for all space requirements
Database sizes range from 200MB to 800MB
Read and Write ratio ranges and I would go with 50/50 at this time

My Questions Are:
1.      What is the best RAID level we should use on the 6140 (RAID1 / RAID5)
2.      Should one let ZFS manage the RAID and rather present the whole disk on the array as a single LUN to the Control Domain – Allocate that LUN to the Guest and then use ZFS to create and manage the RAID level
3.      When we create a logical drive on the 6140 – what will be the best Stripe Size given the below recommendations on the ZFS recordsize

4. My Main Concern here is how to provision the Stripe Size on the underlying disks on the array before presneting them to the Control Domain

Match Oracle Solaris ZFS record size to Oracle database block size - The general rule is to set recordsize = db_block_size for the file system that contains the Oracle data files.
When the db_block_size is less than the page size of the server, 8 KB on SPARC systems and 4 KB on x64 systems, set the record size to the page size. On SPARC systems, typical record sizes for large databases are as follows:

File System      Record Size
Table data      8KB
Redo logs      128KB (Default)
Index files      8KB
Undo data      128 KB (default) or sometimes 8 KB
Temp data      128 KB (default)
Archive data      128 KB (default) compression on
 
Many thanks and I look forward to your replies
ASKER CERTIFIED SOLUTION
Avatar of BigSchmuh
BigSchmuhFlag of France image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answers