- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- Re: EVA8100: Oracle DBA question
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
тАО05-11-2011 04:55 AM
тАО05-11-2011 04:55 AM
----- ----- ----- ----- -----
The Database services group has a requirement to tune the Oracle initialization parameter: "db_file_multiblock_read_count".
To accomplish this goal, it is believed one should tune the parameter to match the number or multiple of the number of blocks the HP - EVA typically works with.
How many blocks does the HP - EVA fetch from disk on a single fetch? Is there an optimal number of blocks that the HP - EVA processes within it's cache when attempting to fulfill a read request?
----- ----- ----- ----- -----
If you can help answer the specific question, that would be great. In the meantime, I am seeking out Oracle/EVA tuning whitepapers.
Thanks,
Mike
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2011 05:42 AM
тАО05-11-2011 05:42 AM
Re: EVA8100: Oracle DBA question
that is 256 x 512-byte blocks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2011 06:09 AM
тАО05-11-2011 06:09 AM
Solution---------------------
VRAID-> 0
PSEG-> 4
DATA-> 4
SIZE-> 8MB
CHUNK-> 64KB
-------------------------
VRAID-> 5
PSEG-> 4+1
DATA-> 4
SIZE-> 10MB
CHUNK-> 80 KB
--------------------------
VRAID-> 1
PSEG-> 4+4
DATA-> 4
SIZE-> 16MB
CHUNK-> 128KB
Now I hope you will be implementing VRAID 1 for Oracle database so go for 128KB.
I work for HPE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2011 08:02 AM
тАО05-11-2011 08:02 AM
Re: EVA8100: Oracle DBA question
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2011 05:09 AM
тАО05-12-2011 05:09 AM
Re: EVA8100: Oracle DBA question
Greetings
Oscar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2011 05:12 AM
тАО05-12-2011 05:12 AM
Re: EVA8100: Oracle DBA question
"CHUNK" seams to mean something completely different and RSTOREs and PSEGs are completely irrelevant for the question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2011 05:35 AM
тАО05-12-2011 05:35 AM
Re: EVA8100: Oracle DBA question
Chunk size is 128KB (256 blocks X 512 bytes) fixed.
1 PSEG = 16 chunk
1 chunk size = 128KB
1 PSEG size = (16 X 128) = 2 MB
I work for HPE