Size of the database

Hi, I have two databases in a single dbspace and I wanna know the size of the database.When I do onstat -d I get only the size of the chunk and pages free. Any one who has done this .Please mail me Regards Shiller

I am not exactly sure what you are looking for. If you are looking for the total number of pages allocated to the database, you can look in sysmaster:sysextents and sum up all of the extent sizes for a particular database. Remember that just because pages are allocated to a table, does not mean you have data in them yet. Dan P Shiller wrote: > Hi, > > I have two databases in a single dbspace and I wanna know the size of > the database.When I do onstat -d I get only the size of the chunk and > pages free. > Any one who has done this .Please mail me > > Regards > Shiller -- ------------------------------------------------- Dan Cearley Sabre Inc. 4333 Amon Carter Boulevard MD 5547 5E3A-48 CP5 Fort Worth, TX 76155 Tel: 817 963 5337 Fax: 817 931 6686 Cel: 972 567 5550 daniel.cearley@sabre.com -------------------------------------------------