Re: My RMAN script of full backup

From: Noons <>
Date: Sun, 29 Apr 2012 22:16:52 -0700 (PDT)
Message-ID: <>

On Apr 30, 7:07 am, Mladen Gogala <> wrote:

> The legend of the database that doesn't need a DBA is just a legend.

Ah yes, that. Good joke. Whoever came up with that at Oracle had a sense of humour.

> the future. RAM sizes are getting much bigger, SSD are getting much more
> common, and MVC frameworks like Hibernate, Zend or Django are becoming
> prevalent. Database algorithms will change, automatic tuning will slowly
> become prevalent, both in the database arena and in the OS arena. At that
> point, SQL tuning, which now comprises a large part of my job, will be
> done by a computer.

I've actually been like that for a while (except for Peoplesoft...). Most of the SQL tuning here is done by developers on copies of production, using either Toad or OEM. They run dbms_stats at the appropriate schedule slots in prod - they know much better than I what those are - for objects of wild volatility. I ensure that once an average SQL goes from dev to prod, its plan doesn't change for the worse. As well as collect stats regularly on low volatility objects. Can't remember the last time we got a "runaway" prod performance problem caused by wild SQL plans - other than the odd bu^H^Hfeature. And that's about it. Got better things to do with my time than "death-by-sql-tuning". KISS. Like it or not.

Of course: I'm not on con-sultancy rates. So I do mostly things like tuning the OS/DB interface, move data based on usage patterns, take advantage of SAN tools and features, monitor and analyze usage trends for capacity planning - CPU, mem, and disk space - and design, test and configure new servers as well as plug holes in MS/SQL here and there. A much better use of the time I'm being paid for.

> When Skynet becomes self aware, the DBA 1.0 personnel
> will become obsolete and will be tehminated.

Tell that to the hordes of "con-sultants" who tried to get me outsourced for the last 5 years... Apparently, upfront we had a "performance problem". Even though no one has been able to pinpont exactly what that problem is. I'm sure as soon as some got in, they'd find "heaps of problems" - at a price. Heck: we don't run complicated RAC/ASM setups, so there M-U-S-T be a problem somewhere, right? Just like the security auditors who come in every 6 months and found nothing "broken" in the last 4 years.

Ah well, Skynet can be fun! ;-) Received on Mon Apr 30 2012 - 00:16:52 CDT

Original text of this message