Database Reference
In-Depth Information
The following query output gives the total extents across various diskgroups from the ASM instance:
SQL> SELECT group_kfdat dg#,
COUNT(number_kfdat) "# of AU's"
FROM x$kfdat
GROUP BY group_kfdat;
DG# # of AU's
---------- ----------
1 4945920
2 133504
3 5376
4 617792
5 824320
ASM keeps track of a file's layout with metadata called an extent map. An extent map is a name-value-pair table
that maps file extents to AUs on disk. Extent maps are primarily used by database instances to map the location of
data on disk.
The following query will help determine the total number of AUs allocated and how many free AUs are available:
SELECT group_kfdat group#,
number_kfdat disk#,
decode(v_kfdat, 'V', 'Used',
'Free') "Used",
COUNT(*) "# of AUs"
FROM x$kfdat
GROUP BY group_kfdat,
number_kfdat,
v_kfdat
ORDER BY group_kfdat,
number_kfdat,
v_kfdat;
GROUP# DISK# Used # of AUs
---------- ---------- ------------ ----------
3 0 Free 616469
3 0 Used 1323
4 0 Free 4491
4 0 Used 885
5 0 Free 73318
5 0 Used 29722
5 1 Free 73317
5 1 Used 29723
5 2 Free 73313
5 2 Used 29727
5 3 Free 73317
5 3 Used 29723
5 4 Free 73314
5 4 Used 29726
5 5 Free 73318
Search WWH ::
Custom Search