Re: Friday Quiz was Re: DBA_DATA_FILES inconsistency?
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 28 Feb 2013 12:52:39 -0800
Message-ID: <CAORjz=M4_ZRrYLjRUghwtTnND6vbxH5bfpAJzrv5vPap3EuM7Q_at_mail.gmail.com>
On Fri, Feb 15, 2013 at 9:06 AM, Niall Litchfield < niall.litchfield_at_gmail.com> 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.
>
Date: Thu, 28 Feb 2013 12:52:39 -0800
Message-ID: <CAORjz=M4_ZRrYLjRUghwtTnND6vbxH5bfpAJzrv5vPap3EuM7Q_at_mail.gmail.com>
On Fri, Feb 15, 2013 at 9:06 AM, Niall Litchfield < niall.litchfield_at_gmail.com> 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 <https://gist.github.com/jkstill/5060010>
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 28 2013 - 21:52:39 CET