Database DataWarehousing (MOSC)

MOSC Banner

Does Oracle make a mistake in this doc?

edited Nov 21, 2010 8:17PM in Database DataWarehousing (MOSC) 2 commentsAnswered
 hi
would any storage-DBA expert explain to me, please, this section of Oracle documentation:
http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/iodesign.htm#i28823
?

I thought for DSS it's recommended to use larger RAID0 stripe's depths (simply : stripe size).
Here, it's written that, opposite, it is so with OLTP.

In example

for OLTP they say the stripe size is like:
n * DB_BLOCK_SIZE => (DB_FILE_MULTIBLOCK_READ_COUNT -1) * DB_BLOCK_SIZE
I assume (at least in my case), usually MBRC is more than 2.

and for DSS:
n * DB_BLOCK_SIZE

Then at the end of this section we find this hint:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center