Re: Segment growth monitoring

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: gogala.mladen@xxxxxxxxx
  • Date: Sat, 14 Nov 2015 14:56:00 -0800

On Sat, Nov 14, 2015 at 12:35 PM, Mladen Gogala <gogala.mladen@xxxxxxxxx>
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

Other related posts: