Phone (800) 766-1884 for immediate Oracle support & training
Free Oracle Tips

Home Home
Oracle Monitoring
Growth Monitoring
Emergency DBA Support
Installs & Upgrades
Oracle Migration
Oracle Support Plan
Oracle SQL Tuning
Oracle Performance Tuning

 Our Remote DBA Clients

 

Free Oracle Tips


 
HTML Text

Free Oracle App Server Tips


 
HTML Text

 

   
  Oracle Tips by Burleson

Chapter 1 Oracle Instance Internals Scripts

With DG_CONFIG, you can dynamically add database to the Data Guard configuration while in maximum availability or maximum protection mode without shutting down databases. 

The following four parameters are related to Automated Storage Management instance (ASM).

The instance_type parameter

The instance_type parameter specifies whether the instance is a database instance or an Automated Storage Management instance.

Values:

  • RDBMS - The instance is a database instance.
     

  • OSM - The instance is an Automated Storage Management instance.

The osm_diskgroups parameter

The osm_diskgroups parameter specifies a list of names of disk groups to be mounted by an Automated Storage Management instance at instance startup or when an ALTER DISKGROUP ALL MOUNT statement is issued.

Automated Storage Management automatically adds a disk group to this parameter when a disk group is successfully mounted, and automatically removes the disk group when it is dismounted (except for dismounts at instance shutdown).

The osm_diskstring parameter

The osm_diskstring parameter specifies an operating system-dependent value used by Automated Storage Management to limit the set of disks considered for discovery.


The above is from the bestselling book Mike Ault’s Oracle Internals Monitoring & Tuning Scripts
It's only $49.95and you can download all the scripts immediately:
 


    Need an Oracle Health Check?

Does your boss blame you for an Oracle performance problem? 
Need to prove that your database is properly optimized?

BC Oracle performance guru's can quickly verify every aspect of your Oracle database and provide a complete certification that your database is fully optimized.

 

 



 

Burleson Oracle consulting & training



 

 

WISE Oracle monitoring software
 

 

Oracle forum for DBA 

 

Rampant TechPress Oracle book publisher

image 

  

 

E-mail us for BC Oracle support:   

Copyright © 1996 -  2012 by Burleson Enterprises. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.