Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Oracle ASM Views and Usage - Quick Reference/Understanding

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Oracle ASM Views and Usage - Quick Reference/Understanding

    V$ASM_DISK
    ===================
    In an ASM instance, contains one row for every disk discovered by the ASM instance, including disks that are not part of any disk group.

    This view performs disk discovery every time it is queried.

    To find the free space in an ASM disk :
    select group_number, disk_number, name, failgroup, create_date, path, total_mb,free_mb from v$asm_disk;

    In a DB instance, contains rows only for disks in the disk groups in use by that DB instance.

    V$ASM_DISKGROUP
    ===================
    In an ASM instance, describes a disk group (number, name, size related info, state, and redundancy type).


    To find the free space in an ASM diskgroup :
    select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup;

    In a DB instance, contains one row for every ASM disk group mounted by the local ASM instance.

    This view performs disk discovery every time it is queried.

    V$ASM_OPERATION
    ===================
    In an ASM instance, contains one row for every active ASM long running operation executing in the ASM instance.

    To see the current ASM operations in Progress :
    select group_number, operation, state, power, actual, sofar, est_work, est_rate, est_minutes from v$asm_operation;

    In a DB instance, contains no rows.


    V$ASM_ALIAS
    ==============
    In an ASM instance, contains one row for every alias present in every disk group mounted by the ASM instance.

    In a DB instance, contains no rows.

    V$ASM_CLIENT
    ===============
    In an ASM instance, identifies databases using disk groups managed by the ASM instance.

    In a DB instance, contains information about the ASM instance if the database has any open ASM files.



    V$ASM_FILE
    In an ASM instance, contains one row for every ASM file in every disk group mounted by the ASM instance.

    In a DB instance, contains no rows.

+ Reply to Thread

Similar Threads

  1. Quick Reference for commonly used Unix / Linux user level Commands
    By Hemant in forum OS for Oracle Administration
    Replies: 0
    Last Post: 06-26-2012, 01:07 AM
  2. Oracle Application Login/Logout Flow. Basic Understanding.
    By pkumar in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 02-24-2012, 12:59 PM
  3. Autoconfig Usage in Oracle Apps 11i and R12
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 5
    Last Post: 02-23-2012, 09:37 PM
  4. Oracle Database V$ Views
    By Pradeep in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 12-14-2011, 05:04 AM
  5. Oracle Database V$ Views
    By Pradeep in forum Oracle Database Administration 10g and 11g
    Replies: 0
    Last Post: 12-14-2011, 05:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics