Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Automatic Storage Management configuration


Automatic Storage Management (ASM) can be configured from the DBCA in all versions starting from Oracle 10gR1. The 11gR2 has separated the ASM configuration into another tool named ASMCA. ASM is a convenient storage method for Oracle Databases starting with Oracle 10gR1.

ASM

ASM is a high performance storage method for Oracle Databases. This allows striping and mirroring, and a regular database can be completely or partially stored in ASM. ASM uses raw disks to store the data, and provides an Oracle-owned file-system structure (metadata) to identify where the data is stored. This provides a balance between Raw storage (high performance) and File systems (manageability) while addressing the unique concerns of a database. In RAC environments ASM is the preferred storage method used in case there is no cluster file system available.

ASM stripes files across the configured physical disks, it allows online disk reconfiguration and rebalancing, and it...