For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

   
  Oracle Tips by Burleson

Easy Oracle Automation
Chapter 5 -
Automatic Storage Management

ASM Architecture

For certain database operations like file creation, ASM intervention is required and the database foreground connects directly to the ASM instance. Whenever a connection is made to the ASM instance, the OSMB process is started dynamically.  Database instances are only allowed to connect to one ASM instance at a time, so they have at most one OSMB background process. 

Like RAC, the ASM instances themselves may be clustered using the existing Global Cache Services (GCS) infrastructure. There is usually one ASM instance per node on a cluster. As with existing RAC configurations, ASM requires that the Operating System make the disks globally visible to all of the ASM instances, irrespective of node. Database instances only communicate with ASM instances on the same node. If there are several database instances for different databases on the same node, they are likely to share the same ASM instance on that node.

A basic component of Automatic Storage Management is the disk group. ASM is configured by creating disk groups, which in database instances can be used as the default location for files created in the database. Oracle provides SQL statements to create and manage disk groups, their contents, and their metadata.

Group services are used to register the connection information needed by the database instances to find ASM instances. Group Services are a part of Oracle’s portable clusterware, which gets automatically installed on every node that runs Oracle10g. ASM eliminates the need for manual disk tuning.

The ASM hierarchy can be explained using a diagram. Compare it with previous versions of Oracle databases.

Figure 5.1 Automatic Storage Management Hierarchy 

 


The above text is an excerpt from:

Easy Oracle Automation
Oracle10g Automatic Storage, Memory and Diagnostic Features

ISBN 0-9745993-6-0

by Dr. Arun Kumar R.
 


For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

  
 

 
 
 
 
Oracle performance tuning software
 
 

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: