REPOST: Re: MONITORING

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.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

========= WAS CANCELLED BY =======:
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Control: cancel <3C506FE0.48C9_at_yahoo.com>
Subject: cmsg cancel <3C506FE0.48C9_at_yahoo.com>
Date: Mon, 28 Jan 2002 01:40:59 GMT
Message-ID: <cancel.3C506FE0.48C9_at_yahoo.com>
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!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.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:40726136

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.