Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to sum dba_data_files by tablespace? Help!!

Re: How to sum dba_data_files by tablespace? Help!!

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 23 Dec 2004 06:16:24 +1100
Message-ID: <41c9c809$0$13948$afc38c87@news.optusnet.com.au>


Frodo wrote:
> After grouping the tablespaces this way the pct_free value has gone
> wrong. Thanks for your help and merry christmas!!

Define "gone wrong". Give us some numbers, show us what you think should be displayed, then show us what your select is actually displaying.

And have you considered simply managing free space in tablespaces via Enterprise Manager?

Regards
HJR Received on Wed Dec 22 2004 - 13:16:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US