Re: used datafile

From: S Bunker <bunkers_at_bigfoot.com>
Date: 2000/06/13
Message-ID: <MIC15.958$Ko2.28497@wormhole.dimensional.com>#1/1

Just a guess, but you might want to join v$datafile (or dba_datafiles) by file_id to dba_segments or dba_extents and group by file_id. You could then have an idea of how much is being used per file_id -- and each file_id corresponds to a specific datafile.

"Wilko" <Wilko_at_yoa.com> wrote in message news:8i6gtd$occ6_at_inetbws1.citec.com.au...
>
> Hi all,
>
> Can someone pls. tell me how
> to find the percentage of tablespace/datafile
> used.
>
> Thanks,
> Chris
Received on Tue Jun 13 2000 - 00:00:00 CDT