RE: ASM monitoring in Enterprise Manager
- From: "Luca Canali" <Luca.Canali@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Mar 2007 11:09:49 +0100
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
