Re: Best course to understand why a bad plan is chosen by optimizer

Hi Clay!

Comments in line:

On 9/23/19 1:19 PM, Clay Jackson (cjackson) wrote:
> I've known Mark for a LONG time, and have ALWAYS been impressed with his elegant "turn of phrase"!

I have never met Mark in my life and I am deeply sorry about it. I am following his contributions on various Oracle forums with a sort of fascination.  I respect hist opinion deeply, even when I disagree with him.

>
>
> I'm going to save this; and, with permission of course, may use it a few talks (I'm doing one in Dallas in a few weeks on "The Future of the DBA in a World of Autonomous Databases").

Databases are extremely complex, even if autonomous. I don't envision being able to utilize a serious business database without having a DBA anytime soon. Also, databases are getting larger. Backup and recovery of 50+ TB database is not as simple as it may look. Look at the databases as modern airplanes. No robot can do what Sully Sullenberger has done. Auto-pilot is available for the long time but I would be very hesitant to fly an airplane which doesn't have a pilot on board.

>
> I think sometimes we forget the "Engineering" ; and I'm 100% certain my mother was correct, when, in 1970, she predicted "Cost Accounting will be the ruin of civilization".

With all due respect, I disagree with your mother. Cost accounting is a necessary evil. You can call me crazy, but I prefer the money to be spent on my bonus over buying unnecessary software. My bonus is never unnecessary.

>
> Clay Jackson
> Database Solutions Sales Engineer
> clay.jackson_at_quest.com
> office  949-754-1203  mobile 425-802-9603

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