Re: DBA_HIST_SYSMETRIC_HISTORY and metric I/O Megabytes per Second

I am using ASM.

I am measuring database I/O bandwith throughput, I had a script whcih snaps v$sysmetric every 5 minutes, I was thinking to stop using it and instead query this metric but it doesnt seem correct numbers!

Thanks

--
LSC


On Fri, May 13, 2011 at 4:33 AM, David Mann <dmann99_at_gmail.com> wrote:



> >Hi all

> >Anyone know if the metric I/O Megabytes per Second is valid in

> >DBA_HIST_SYSMETRIC_HISTORY at version 11gR1?

> >I am checking some I/O throguhput in a pretty loaded system (around

> >1200MB/sec) and this metric shows some really low value like 6MB/sec!

>

> How is the storage with your datafiles attached? I was looking for

> similar information in OEM to match up with iostat numbers I was

> observing on some NFS mounts... but at least in this case OEM only

> 'knew' about locally attached drives, not the NFS mounts where the

> real action was happening. So I observed something similar, busy

> database but OEM was only telling me about the light activity going on

> locally (Oracle binaries and OS activity). Maybe we are seeing

> something similar?

>

> -Dave

>

> --

> Dave Mann

> www.brainio.us

> www.ba6.us - Database Stuff - http://www.ba6.us/rss.xml

> --

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

>

>

>


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