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

Easy Oracle Automation
Chapter 5 -
Automatic Storage Management

Disk Group Templates

ALTER DISKGROUP dskgrp01 ALTER TEMPLATE DBAHELPER1 ATTRIBUTES (COARSE);

To drop an existing template, use the DROP TEMPLATE clause. This can be applied to one or more templates from a disk group. System defined templates supplied by Oracle cannot be dropped. Only user defined templates can be dropped.

To drop the DBAHELPER1 template, issue the following command:

ALTER DISKGROUP dskgrp01 DROP TEMPLATE DBAHELPER1;

The next topic that will be explored involves disk group directories.

Disk Group Directories

A disk group contains a hierarchical directory structure with fully qualified file names along with alias filenames. On a new file creation, the system alias is automatically created by ASM. To create more friendly aliases for filenames, a directory structure has to be created to support the new naming conventions.

To create a new directory, use the ADD DIRECTORY clause of the ALTER DISKGROUP command.  The directory path should begin with a plus (+) sign, followed by subdirectory names separated by forward slash (/) characters.

An example using the dskgrp01 disk group would be as follows:


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.
 


    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.