ASM free space in diskgroup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ASM free space in diskgroup

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    ASM free space in diskgroup

    Hi all,

    I have an ASM diskgroup with normal redundancy on RHEL 3. Below is the free space it shows:

    Code:
    PATH                             TOTAL_KB    USED_KB    FREE_KB PERCUSED
    ------------------------------ ---------- ---------- ---------- --------
    /dev/raw/raw1                  1073740800  910274560  163466240       85
    /dev/raw/raw2                  1073740800  910439424  163301376       85
    /dev/raw/raw3                  1073740800  910441472  163299328       85
    /dev/raw/raw4                  1073740800  910404608  163336192       85
    /dev/raw/raw5                  1073740800  910384128  163356672       85
    /dev/raw/raw6                  1073740800  910366720  163374080       85
    raw 1,2,3 form the primary group and 4,5,6 form the failure group. Now the question i have is regarding free space. In the primary group do i have 155GB free or 155GB*3?

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You should not query v$asm_disk to get the free space information.
    rather you should be querying v$asm_diskgroup view.

    What version of ASM is this 10.1 or 10.2 and also what is the level of redundancy ?

    regards
    Hrishy

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    Hi,

    The level of redundancy is normal and version is 10.2.0.3

    Thanks

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Query v$asm_diskgroup look for the column usable_free_space

    regards
    Hrishy

Posting Permissions

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


Click Here to Expand Forum to Full Width