Re: How do I find out what just ate a big bite of our chunkspace?

SRC wrote: > > 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?) > Is that valid data? > Any info. appreciated (even an RTFL page#) > Thanks in advance! > -Richard Ross > > ross@charlie.ece.sc.edu You can use the 'tbcheck -pe' command to print the extents and pages allocated to each table in your database(s). If you run it every day (or once a week), you can compare the output and it'll show you which tables are growing. Hope this helps. Stefanie Vario ZenaComp, Incorporated svario@zenacomp.com