RelationalDBDesign RelationalDBDesign

Tuning Instance   «Prev 

(ASM) Automatic Storage Management

Oracle Database 10g introduced Automatic Storage Management (ASM) which provides a file system and volume manager in the database, enabling automated striping of files and automating mirroring of database extents. DBAs simply define 1) a pool of storage or 2) disk group and manage the disk group through Enterprise Manager. Disk groups are created with normal redundancy as the default (2-way mirroring). You can also create disk groups with high redundancy (3-way mirroring) or external redundancy (no mirroring). Failure groups are ASM disks that share a common failure point, so mirroring will automatically occur to a different failure group to provide high availability. Oracle manages the files that are stored in ASM disk groups. ASM can manage Oracle datafiles, logfiles, control files, archive logs, and RMAN/backup sets. Workloads can be dynamically rebalanced as storage is reconfigured such that when storage is added or removed from the pool, data can be redistributed in the background.

File System Components

Redo Activity 1) MAX 2) AVG 3) MB 4) DAY 5) TWO_DAY

Max Shows the maximum number of log switches per day
AVG Shows the average number of log switches per day
MB The redo log size
DAY The maximum number of megabytes required per day
TWO_DAY Since some DBAs want to size the archived redo log file system to hold two days' worth of updates, this column shows the maximum amount of redo log space over a two-day period.