REPOST: Re: MONITORING

On Thu, 24 Jan 2002 20:34:40 +0000, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

>Brian Tkatch wrote:
>>
>> When is an item considered stale, so that GATHER STALE collects
>> recollects statistics?
>>
>> Also, I hacked this together:
>>
>> SELECT UT.Table_Name, UT.Num_Rows,
>> UTM.Inserts, UTM.Updates, UTM.Deletes,
>> ROUND((UTM.Inserts + UTM.Deletes) / DECODE(UT.Num_Rows, 0, 100,
>> UT.Num_Rows) * 100, 2) || '%' "Percent Added/Deleted",
>> ROUND((UTM.Inserts + UTM.Updates + UTM.Deletes) /
>> DECODE(UT.Num_Rows, 0, 100, UT.Num_Rows) * 100, 2) || '%' "Percent
>> Changed",
>> UT.Last_Analyzed, UTM.Timestamp "Modification time"
>> FROM User_Tables UT, User_Tab_Modifications UTM
>> WHERE UT.Table_Name = UTM.Table_Name
>> ORDER BY (UTM.Inserts + UTM.Updates + UTM.Deletes) /
>> DECODE(UT.Num_Rows, 0, 100, UT.Num_Rows) DESC
>>
>> Does it make sense?
>>
>> Brian
>
>I remember reading somehwere that gather_stale is based on 10% deltas,
>but please don't take that as gospel.

But 10% of INSERTs and DELETEs, or do UPDATEs count as well.

I'm watching GATHER STALE. I just want to know what to watch.

Brian

• WAS CANCELLED BY =======: From: SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) Control: cancel <3c50822d.1434238844_at_news.alt.net> Subject: cmsg cancel <3c50822d.1434238844_at_news.alt.net> Date: Mon, 28 Jan 2002 01:15:20 GMT Message-ID: <cancel.3c50822d.1434238844_at_news.alt.net> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.belwue.de!newsfeed.arcor-online.net!newsfeed.r-kom.de!newsfeed.freenet.de!peer.news.opaltelecom.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40724563

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 15:53:27 CST