Database Tuning (MOSC)

MOSC Banner

asm vs tablespace vs table vs index

edited Jul 10, 2009 5:26AM in Database Tuning (MOSC) 3 commentsAnswered
 Hi!

Before asm, a best practice said,  "create tablespace for tables" and "create tablespace for indexes" both on a different diskdrive

ex:  tablespace_DATA  on drive    and tablespace_INDEX on drive E:

my question is

with asm, whats the best way for keep the best performance...

1. create one diskgroup and create all tablespace on it

or

2. create one diskgroup for DATA  and one diskgroup for INDEX  and create tablespace_DATA on the first and create tablespace_INDEX on the second

thanks for your help

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