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


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  Oracle Tips by Burleson

Easy Oracle Automation
Chapter 5 -
Automatic Storage Management

Dynamic Performance Views on ASM

Column

Description

LIBRARY

Library name that discovered the disk

TOTAL_MB

Total disk capacity in megabytes

FREE_MB

Unused disk capacity in megabytes

NAME

Disk name

FAILGROUP

Failure group name containing the disk

LABEL

Disk label name

PATH

Operating system pathname

UDID

Universal Device ID

CREATE_DATE

Date and time of adding the disk to the disk group

MOUNT_DATE

Date and time when the disk was mounted by the first instance

REPAIR_TIMER

Seconds remaining until the disk is automatically dropped (0 if not failed)

READS

Total number of I/O read requests to the disk

WRITES

Total number of I/O write requests to the disk

READ_ERRS

Total number of failed I/O read requests to the disk

WRITE_ERRS

Total number of failed I/O write requests to the disk

READ_TIME

Total I/O time for read requests for the disk in hundredths of a second (if timed_statistics =TRUE, or 0 if FALSE)

WRITE_TIME

Total I/O time for write requests for the disk in hundredths of a second (if timed_statistics=TRUE, or 0 if FALSE)

BYTES_READ

Bytes read from the disk

 


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.
 


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

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

 

   

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

Oracle® is the registered trademark of Oracle Corporation.