- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Appropriate size of Hp-ux block while creating...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2003 06:46 PM
тАО09-24-2003 06:46 PM
Appropriate size of Hp-ux block while creating Oracle database ( OLTP or DSS)
Is there any hard or fast rule for configuring ur HP-UX 11i box for creating oracle datawarehouse with a block size of 32k ?
thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2003 07:11 PM
тАО09-24-2003 07:11 PM
Re: Appropriate size of Hp-ux block while creating Oracle database ( OLTP or DSS)
As large table scans are common ( both indexed and full ) on DSS, if your OS BS is 8k then your database blocksize should be a factor of this , say 16k. Yes it will cause more I/O at the OS level but if your data is well maintained and not fragmented then most of the blocks would be contiguous and the OS would not have to perform a lot more work. Also what will help is if your Disks have a lot of read cache. If you have Full table scans going on make sure you have a good Muti block read count setting as this will help speed up those scans.
I have found the max for block size on an VXFS file system is 8k. In your case, if you use 32K DB_BLOCK_SIZE, there is relatively less overhead, thus more room to store useful data, good for sequential access, or very large rows, therefore it is ok for a DSS.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2003 08:25 PM
тАО09-24-2003 08:25 PM
Re: Appropriate size of Hp-ux block while creating Oracle database ( OLTP or DSS)
There is no hard / fast rule for configuring your HP-UX 11i box of that block size should it be for oracle database.
For good performance Oracle Block size should be made equal to or a multiple of the O/S blocksize. Normally Oracle DB_BLOCK_SIZE will be in 4K, 8K, 16K....etc
In an OLTP system you generally pick out only a few records to work on in any particular transaction/query. The plan normally used would only pull in one or two blocks in order to pick out 3 or 4 records from them. The I/O time is greater to pull in a large block, merely to get a few rows. Block size 8K is more appropriate for an OLTP application.
Balance DB_block_size with Operating System Block Size. For good performance Oracle Block size should be made equal to or a multiple of the O/S blocksize. It is not sensible to have the size SMALLER than the OS blocksize as a single read will actually read in 'OS block size bytes' even if only part of this is passed on to Oracle.
Matching the Oracle and OS block sizes results in one Oracle IO block request being one OS IO request. For a good argument for db_block_size = fs_block_size.
IA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2003 08:39 PM
тАО09-24-2003 08:39 PM
Re: Appropriate size of Hp-ux block while creating Oracle database ( OLTP or DSS)
Hi,
We have it as 8K. As recommended by SAP.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2003 11:07 PM
тАО09-24-2003 11:07 PM
Re: Appropriate size of Hp-ux block while creating Oracle database ( OLTP or DSS)
and a few line here
Oracle recommends 8k block size if u are uncertain and that for Large Transaction Processing Environments
Smaller Block size:
When rows are small and random acces alot.
Good for OLTP
Larger Block Size :
When rows are large and sequential access.
Good for DSS
the scale for Block size is as
8K 16K 32K 64K
<---OLTP DSS --->