Gathering Information

From: <amerar_at_ci.chi.il.us>
Date: Mon, 27 Sep 1999 16:21:30 GMT
Message-ID: <7so5hs$h3t$1@nnrp1.deja.com>

Hello,

We are about to move our database to a new machine. Before doing so, we have decided to re-create the filesystems so they can handle the database for the next 2 years. At the same time, I may increase some of the tablespace sizes.

I am looking to create a query that will show me by tablespace/table the current storage allocation and important parameters.......I'm not sure how I should approach this.

Any suggestions?

Thanks,

Arthur
amerar_at_ci.chi.il.us

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 27 1999 - 11:21:30 CDT