Disk Enclosures
1748052 Members
4758 Online
108758 Solutions
New Discussion юеВ

Re: EVA8100: Oracle DBA question

 
SOLVED
Go to solution
Michael T. Slack
Occasional Advisor

EVA8100: Oracle DBA question

pasted question from Oracle DBA
----- ----- ----- ----- -----
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
6 REPLIES 6
Uwe Zessin
Honored Contributor

Re: EVA8100: Oracle DBA question

The EVA's internal chunk-size is 128KB -
that is 256 x 512-byte blocks.
.
Solution

Re: EVA8100: Oracle DBA question

1 Vdisk RSTORE =
---------------------

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
Accept or Kudo
Michael T. Slack
Occasional Advisor

Re: EVA8100: Oracle DBA question

Thank you for the quick responses!
Oscar_Maim├│
Regular Advisor

Re: EVA8100: Oracle DBA question

I believed that EVA chunk size was always the same (128K) regardless RAID type. I was wrong...???
Greetings
Oscar
Uwe Zessin
Honored Contributor

Re: EVA8100: Oracle DBA question

I agree with you...
"CHUNK" seams to mean something completely different and RSTOREs and PSEGs are completely irrelevant for the question.
.

Re: EVA8100: Oracle DBA question

I am sorry about the post.

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
Accept or Kudo