zhu chao 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
V$ data is not, log history excepted, historical - just a snapshot. You just need the list of V$ views you want to keep track off, create your own set of tables with just an additional TIMESTAMP date column, and insert ... select sysdate, .... from V$... at regular intervals. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
