Home » Server Options » RAC & Failsafe » about asm AU issue
about asm AU issue [message #575458] Wed, 23 January 2013 07:53 Go to next message
Teddyboy
Messages: 8
Registered: September 2005
Junior Member
OS: suse linux 11, 11g rac,

SQL> select name, ALLOCATION_UNIT_SIZE, type from v$asm_diskgroup;

NAME
--------------------------------------------------------------------------------
ALLOCATION_UNIT_SIZE TYPE
-------------------- ------------------
DG_DATA1
             1048576 EXTERN
DG_DATA2
             1048576 EXTERN
DG_DATA3
             1048576 EXTERN
DG_OCR
             1048576 EXTERN


SQL> select file_name, bytes from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
     BYTES
----------
+DG_DATA1/crmdb/datafile/users.259.805398403
   5242880

SQL> select GROUP_KFFXP Group#, DISK_KFFXP Disk#, AU_KFFXP AU#, XNUM_KFFXP Extent# 
  2  from X$KFFXP 
  3  where number_kffxp=(select file_number from v$asm_alias where name='&alias_name');
Enter value for alias_name: USERS.259.805398403
old   3: where number_kffxp=(select file_number from v$asm_alias where name='&alias_name')
new   3: where number_kffxp=(select file_number from v$asm_alias where name='USERS.259.805398403')

    GROUP#      DISK#        AU#    EXTENT#
---------- ---------- ---------- ----------
         2          0        441          0
         2          2        444          1
         2          1        441          2
         2          0        442          3
         2          2        445          4
         2          1        442          5


my question is:

DG_DATA1 is external type, no redundancy, and AU size is 1M,
datafile +DG_DATA1/crmdb/datafile/users.259.805398403 size is 5M, but why it has 6 AUs?

and why the AU number is 441,444,441,442,445,442,
can AU cross two disks? i think it can't.

can any one give some explanation?

kind regard's

Teddy.
Re: about asm AU issue [message #575465 is a reply to message #575458] Wed, 23 January 2013 08:16 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
X$ tables are for Oracle only.
Why are you trying to use this table?

Regards
Michel
Previous Topic: Download Clusterware 11g
Next Topic: rshd and rexecd
Goto Forum:
  


Current Time: Thu Mar 28 17:28:13 CDT 2024