Re: Friday Quiz was Re: DBA_DATA_FILES inconsistency?
- From: rjamya <rjamya@xxxxxxxxx>
- To: Jared Still <jkstill@xxxxxxxxx>
- Date: Thu, 28 Feb 2013 16:10:13 -0500
On Thu, Feb 28, 2013 at 3:52 PM, Jared Still <jkstill@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
