Re: awr history
From: Karl Arao <karlarao_at_gmail.com>
Date: Sun, 16 Jan 2011 12:01:14 +0800
Message-ID: <AANLkTi=BW9UQp3iPjo75yWQyp1BBgbT9Ns=TK48pkKqE_at_mail.gmail.com>
I agree with you John, I remember having a scenario where I want to have a time series Interconnect Traffic on 3 node RAC environment on 10.2.0.4. I need to get this data to correlate if I'm having an interconnect saturation. Apparently 10g does not have a DBA_HIST table for it... so I was using kSar (http://sourceforge.net/projects/ksar/) and checking it against the raw AWR reports you can see the details on this image
Date: Sun, 16 Jan 2011 12:01:14 +0800
Message-ID: <AANLkTi=BW9UQp3iPjo75yWQyp1BBgbT9Ns=TK48pkKqE_at_mail.gmail.com>
I agree with you John, I remember having a scenario where I want to have a time series Interconnect Traffic on 3 node RAC environment on 10.2.0.4. I need to get this data to correlate if I'm having an interconnect saturation. Apparently 10g does not have a DBA_HIST table for it... so I was using kSar (http://sourceforge.net/projects/ksar/) and checking it against the raw AWR reports you can see the details on this image
http://lh5.ggpht.com/_F2x5WXOJ6Q8/TTJpfiKQPaI/AAAAAAAABA8/7WHc3xQGlk8/RACInterconnectTraffic.png
I'm still on the process of figuring out how to get the "Estimated Interconnect traffic" in a time series manner in 10gR2 but on the newer version here are the relevant DBA_HIST views...
In 11g
Interconnect Ping Latency Stats - DBA_HIST_INTERCONNECT_PINGS
In 11gR2
Interconnect Throughput by Client - DBA_HIST_IC_CLIENT_STATS
Interconnect Device Statistics
- DBA_HIST_IC_DEVICE_STATS, DBA_HIST_CLUSTER_INTERCON
-- Karl Arao karlarao.wordpress.com karlarao.tiddlyspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 15 2011 - 22:01:14 CST