Re: Pages used per table

Russ Kahler (russell@oncontact.com) wrote: : >yes there is an easy answer. : run oncheck -pt <datbase>:<table> : this will show you complete table space info. : Russ.... : : From ellis.oncontact.com!rmy.emory.edu!informix-list-owner Mon Dec 18 10:25:44 1995 : > Date: Mon, 18 Dec 1995 10:43:47 -0500 : > From: Bruce Cota <cota@dpg.rnb.com> : > Message-Id: <9512181543.AA28826@dpg.rnb.com> : > To: informix-list@rmy.emory.edu : > Subject: Pages used per table : > Sender: informix-list-owner@rmy.emory.edu : > Reply-To: Bruce Cota <cota@dpg.rnb.com> : > X-Informix-List-To: russell@oncontact.com : > X-Informix-List-Id: <list.8246> : > : > : > Hi, I think (hope) this has a simple answer ... : > : > With Online-7.1, what is the easiest way to find the number of pages : > allocated to *each* of our tablespaces, *including* pages allocated to : > indexes. We are about to reload all our tables and we're trying to : > determine the appropriate extent sizes... : > : > : > Thanks in advance, : > -Bruce : Russell P. Kahler |||||/// ---------- : Internet: russell@oncontact.com ======== / Uh... : on!contact Software . | O O | /Just reboot : W67 N250A Evergreen Blvd | v_' / --> that will / : Cedarburg, WI 53012 # _| |_ fix it / : (414) 375-6555 (#) ( ) ---------- : # //|* *| : #//( * )/ : # ===== : # ( ) : Blah, Blah, Blah. # || || : .#---'| |----. : #----' ----- Hi! I think the easiest way to get the no. of pages is query npused column in systables table. ex. select tabname,npused from systables where tabid >99 If you are using a seperate dbspace for indexes you have to query sysfragments (I think it is a SMI table) to get pages used by indexes. Good Luck! Dhammika.