Why not issue queries against the statspack tables to get your info?
(if you are using statspack that is)
-Joe
- zhu chao <chaospku_at_163.net> wrote:
> hi, list friends:
> We know statspack can gather history data and let you compare
> statistics from different time snapshot.But it is something
> difficult, for you must make multiple report and open them one by
> one and compare data between different reports.
> Now i want to gather some information about the system ,put them
> in log file and draw pictures(using mrtg from log) about the
> statistics change,so that i can see which statistics is changing
> recent time and find problem before it became performance
> bottleneck or before it stuck the system.
> In fact, the most useful data i want to get is like the content in
> the statspack, but i want to get them into one file from different
> time snapshot.The data i want to gather is like: wait event change
> trend,instance load profile change trend, the most cost sql
> change.Is it possible to get these data directly from some join of
> v$views? Or i can gather such valuable information from some
> v$view?
> Please share your experience about performance monitoring and
> capacity planning:)
>
>
> Regards
> zhu chao
> Eachnet DBA
> 86-21-32174588-667
> chao_ping_at_vip.163.com
> www.happyit.net
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: zhu chao
> INET: chaospku_at_163.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like
subscribing).
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
Received on Tue Sep 10 2002 - 10:54:51 CDT