Re: Friday Quiz was Re: DBA_DATA_FILES inconsistency?

From: Jared Still <>
Date: Thu, 28 Feb 2013 12:52:39 -0800
Message-ID: <>

On Fri, Feb 15, 2013 at 9:06 AM, Niall Litchfield <> wrote:
> . Norm is right correctly deciding how much free space a tablespace
> has is rather complex - especially when you consider that frequently DBAs
> don't consider the volume size on the volume on which autoextend datafiles
> are put.

I've been using this one for quite some time, which takes into account autoextend,
but alas does ignore system space constraints - that cannot be done simply in SQL.

showdf.sql <>

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:

Received on Thu Feb 28 2013 - 21:52:39 CET

Original text of this message