Database DataWarehousing (MOSC)

MOSC Banner

Partitions by hash use One or Multi ablespace on ASM

edited Nov 7, 2013 7:52AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi,


 We are using the 32 Tablespaces for 32 Partitions Partitions by hash on the ASM. My Questions is :-

1) For having this multi table-spaces for each partitions in a  on a ASM Will this increase performace ?

2) OR Will it be not any effect on any performance if we were having all partitions went to one tablesapce on the  ASM .

So Question is :- Is it better to have one tablespace for for each PArtitions or have Multi tablespace for each partitions on a ASM. when partitions by hash.

Regards
Sahil Soni

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