Database - RAC/Scalability (MOSC)

MOSC Banner

Disks size in a diskgroup

edited May 17, 2014 12:00PM in Database - RAC/Scalability (MOSC) 5 commentsAnswered

Hi, I ran the query below

  1*  select name,group_number,path, total_mb/1024 size_gb , failgroup , redundancy from v$asm_disk order by 1,2

NAME                           GROUP_NUMBER PATH                                                       SIZE_GB FAILGROUP                      REDUNDA
------------------------------ ------------ ------------------------------------------------------- ---------- ------------------------------ -------
DATA_0000                                 3 /dev/rdsk/c0d2s6                                       1023.99121 DATA_0000                      UNKNOWN
FRA_0000                                  4 /dev/rdsk/c0d6s6                                        399.960938 FRA_0000                       UNKNOWN
OCR_0000                                  5 /dev/rdsk/c0d3s6                                        3.99902344 OCR_0000                       UNKNOWN
OCR_0001                                  5 /dev/rdsk/c0d4s6                                        3.99902344 OCR_0001                       UNKNOWN
OCR_0002                                  5 /dev/rdsk/c0d5s6                                        3.99902344 OCR_0002                       UNKNOWN

if you look at first two rows then we will see that the sizes are 1024 GB, and 400 GB approximately. How can we have such a big disk allocated from SAN? Are there disks that big available ? Is the query wrong to find out the size of each disk attached to a diskgroup?  Please correct me if I'm wrong.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center