Re: Q:How can I find what just ate alot of our chunkspace?

SRC <src@conterra.com> wrote in article <5ilvr0$eua@hawaii.conterra.com>... > Warning: Experienced admin. but newbie DBA > > We are running Online v 5.05.UC2. Our 'pages available' on our database > grows slowly except for large jumps that occur ~once a month. We would > be at 100K pages for weeks, then go down to 6K in a day. How can I find out > what all of this info. is or what loaded it? (or even what time it was >loaded?) > ... The source of jumps is probably a large table aquiring a new extent. To see precisely what is happening, run 'tbcheck -petT' command occasionally (it locks everything or even requires exclusive access to the database - I don't remember which - so if you are a 7x24 shop, you are in trouble). The command will report, among other things, first and subsequent extent size for all tables, how many of allocated pages are actually used, how much space is used, and how much wasted, by each index etc. Don't rely on number-of-pages-used column in systables, since it doesn't take into account pages allocated for indices. -- Dragi Raos 4-MATE Information Engineering (http://www.4mate.hr) Zagreb, Croatia >