oracle IO

[karfai]

oracle block size is 8k .
read_perf_io = 64 k , read_nstream = 1
stripe size is 128k.

Question is : if the oracle is requesting 8k , will it get back an IO block of 64k or 128k ?

Does the read_perf_io works for seq / random IO?

[Eric Antunes]

Hi karfai,

Check this thread about this:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=257834.999

Best Regards,

Eric

[Spike Burkhardt]

Eric, I'd love to check out the document but you need to have a login :-((

spike

[Eric Antunes]

Hi Spike,

The more important, for good performance, is to have Oracle db_block_size equal to or a multiple of the O/S blocksize (the thread is attached).

Regards,

Eric Antunes

[Eric Antunes]

See also this thread about db_block_size: http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=925671