Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine block size of OS

Status
Not open for further replies.

ShikhaMohan

IS-IT--Management
Nov 17, 2002
2
IN
Through which command do i determine the block size of OS
in Hp-UX 9000
 
I'am not sure about HP but on Solaris you can try one of the following:

fstyp -v /dev/rdsk/cXtYdAsB | grep bsize <-- data block size.
-or-
df -g | grep &quot;block size&quot;
 
Hi,
Thanx for the answer. But this gives me the File system block size. I want to know the OS Block Size. My main motive is that I want to install Oracle under HP-UX 11.0.
I want to know the block size of the OS so that I can give the data block size in the init file in Oracle.
 

What is OSblock size?? Do you mean page size andwhy is that relevant for Oracle??

Cheers Henrik Morsing
IBM Certified AIX 4.3 Systems Administration
 
Oracle's idea of blocksize, which it uses to organise its data files, should match (or be a multiple of, as I remember) the block size for that file-system/disk for efficiency. Mike

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

It's like this; even samurai have teddy bears, and even teddy bears get drunk.
 
Usually oracle data block size depends on your application, if your db is OLTP, 8 should be enough, and if you are in data warehouse environment 16 will be good. If you want to decide if your Oracle software can be installed on your OS, you need know the software is 16 bits or 32 bits, and it should be on your software package. To determine the bits of your OS(solaris) type

isainfo -b

it will print the number of bits.

Hopefully this answers your question.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top