Re: Segment growth monitoring
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 14 Nov 2015 15:35:44 -0500
Message-ID: <56479B20.3060405_at_gmail.com>
On 11/14/2015 02:37 PM, Jared Still wrote:
> DBA's should not
> - be spending time reacting to space issues.
> - be spending time adding datafiles to tablespaces
>
> This can all be automated for the most part.
Date: Sat, 14 Nov 2015 15:35:44 -0500
Message-ID: <56479B20.3060405_at_gmail.com>
On 11/14/2015 02:37 PM, Jared Still wrote:
> DBA's should not
> - be spending time reacting to space issues.
> - be spending time adding datafiles to tablespaces
>
> This can all be automated for the most part.
I beg to differ. DBA should carefully consider where to add space and how much to add. OMF, automatic file extension and alike are only band aid. There are faster LUN devices and there are slower LUN devices, sometimes using RAID-5 protection. There are also flash devices. Deciding from which storage pool to allocate space is non-trivial and depends on the business needs. It would be very hard to allocate properly. Real automation is possible only for the BIGFILE tablespaces, but they are very rarely used, and for good reason. Restoring of a BIGFILE tablespace can be a nightmare.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Nov 14 2015 - 21:35:44 CET