Re: Segment growth monitoring

From: Jared Still <jkstill_at_gmail.com>
Date: Sat, 14 Nov 2015 14:56:00 -0800
Message-ID: <CAORjz=Mc=4CXaoN2-Grfmv4R8wy5MRtQOQPiB_2aA5S=7cc_Dg_at_mail.gmail.com>

On Sat, Nov 14, 2015 at 12:35 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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.

Hi Mladen,

As you know, modern storage no longer works that way.

On medium to large SANs the DBA usually has no control over where the data is stored.

A mixture of devices (SSD and actual disks) is probably in use, with the SAN deciding in most cases what goes where.

Tiered storage decisions should be automated. Both SAN OS' and Oracle 12c+ can automate this.

Sure, there is planning required to decide what goes where.

Time spent on storage minutia is no longer beneficial, at least not on new systems.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Nov 14 2015 - 23:56:00 CET