Re: Friday Quiz was Re: DBA_DATA_FILES inconsistency?
From: rjamya <rjamya_at_gmail.com>
Date: Thu, 28 Feb 2013 16:10:13 -0500
Message-ID: <CAGurbTP7J0c2eX-3z1t4EVg3F-QGBLYhaoyP2TeoG8jsJeEE2g_at_mail.gmail.com>
On Thu, Feb 28, 2013 at 3:52 PM, Jared Still <jkstill_at_gmail.com> wrote:
> but alas does ignore system space constraints - that cannot be done simply in
> SQL.
> showdf.sql <https://gist.github.com/jkstill/5060010>
>
Date: Thu, 28 Feb 2013 16:10:13 -0500
Message-ID: <CAGurbTP7J0c2eX-3z1t4EVg3F-QGBLYhaoyP2TeoG8jsJeEE2g_at_mail.gmail.com>
On Thu, Feb 28, 2013 at 3:52 PM, Jared Still <jkstill_at_gmail.com> wrote:
> but alas does ignore system space constraints - that cannot be done simply in
> SQL.
> showdf.sql <https://gist.github.com/jkstill/5060010>
>
if your db/host) is being monitored by OEM, then you probably can run such query on oem repo db. Since oem will expose all that data (df usage, fs mount usage, asm usage) in views. I wouldn't recommend to rely on it for mission critical databases, but only if you feel adventures enough
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 28 2013 - 22:10:13 CET