Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ASM monitoring in Enterprise Manager
I would first use asmcmd to look for those dead files you suspect to have.
As for the internals, that sounds strange compared with what I typically see in my ASM diskgroups.
Anyway you can get query for more info on all allocated ASM files, including metadata from x$kffil and x$kfdat (see examples below):
select group_kffil group#, number_kffil file#, filsiz_kffil filesize_after_mirr,
filspc_kffil raw_file_size
from x$kffil;
select group_kfdat group#,FNUM_KFDAT file#, sum(1) AU_used
from x$kfdat where v_kfdat='V'
group by group_kfdat,FNUM_KFDAT,v_kfdat;
I hope this can be of help. Cheers,
Luca
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter McLarty
Sent: Friday, March 16, 2007 1:44 AM
To: oracle-l_at_freelists.org
Subject: ASM monitoring in Enterprise Manager
Hi ASM gurus
I am trying to find out why when in EM and I look up the page for the Diskgroup the pie graph Disk Group Usage shows the an amount used for internal that is currently 28%.
I have my suspicions that this is from an earlier process of when we refreshed some databases that we now have dead files in ASM. Is there a way to find out the reason ASM wants 28% of my storage for internal?
I cant find any reference to this in any documentation
ASM is on 10.0.2.3
Cheers
--
Peter McLarty
Database Administrator
Student System Upgrade Project
Central Queensland University
Email: p.mclarty_at_cqu.edu.au Phone: 07 4923 2797 Fax: 07 4923 2721
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 16 2007 - 05:09:49 CDT
![]() |
![]() |