Database Administration (MOSC)

MOSC Banner

Space allocation when using SAN

edited Apr 7, 2010 7:41AM in Database Administration (MOSC) 6 commentsAnswered
 Hello all,

We are moving from a dedicated application/database server environment to separate application and database environments.  The new database server will use a SAN for storage.

Our current setup uses a 16K blocksize and an 8 block multyblock read count and provides good performance.  We try use best practices of Oracle Flexible Architecture but this will not be possible as we have no way of knowing where the database data will actually wind up on the SAN.

So far my research says that we should have different "filesystems" for control files, redo logs, archived logs, undo and temporary tablespaces.  The actual data should be in a different filesystem with segments grouped acording to volatillty (reference vs update), type (index vs table) and next extent size (small, medium, large, Xlarge).  An Oracle instructor once told me during the tuning course what those sizes were but he also added that Oracle was in the business of selling disks so I didn't pay much attention.

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