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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Peter McLarty
Sent: Friday, March 16, 2007 1:44 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx
 Phone:  07 4923 2797
   Fax:  07 4923 2721
Mobile:  04 0209 4238
 
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: