Why not issue queries against the statspack tables to get your info? (if you are using statspack that is)
-Joe --- zhu chao <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > www.happyit.net > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: zhu chao > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
