Re: Sum of selectes Table Spaces in Oracle Enterprise Manager

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 26 Jul 2007 06:13:56 -0700
Message-ID: <1185455636.754284.326820@j4g2000prf.googlegroups.com>

On Jul 26, 7:10 am, "Peter L." <blueche..._at_caramail.com> wrote:
> Hi Newsgroup,
>
> Does anybody know how to get the sum uf the size of a selected set of
> table spaces in Oracle Enterprise Manager?
>
> Thanks & regards,
>
> Peter

Take a look at the Oracle dictionary view dba_data_files. You can sum the size of all the files that make up a specific tablespace or set of tablespaces easily using this view.

HTH -- Mark D Powell -- Received on Thu Jul 26 2007 - 08:13:56 CDT