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

I've known Mark for a LONG time, and have ALWAYS been impressed with his elegant "turn of phrase"!

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

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

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mark W. Farnham Sent: Monday, September 23, 2019 8:10 AM To: gogala.mladen_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Best course to understand why a bad plan is chosen by optimizer

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.

Automation, like constraints on free speech, is a two edged sword.

A bit of sarcasm between two confident senior professionals, if I were sitting in the seat of the admin, would be given wide latitude whilst making a neophyte seeking help appear to be an idiot would face a narrow gate. Fortunately (for everyone involved, most especially me) I don't sit in that seat and I can't remember whether it has been multiple decades or merely many years since anyone has left the gray area in the dust.

Unless there is snow on the ground, the automatic "distance behind" the bumper in front of me automation on my 2017 Subaru is good enough that I let it do that on the highway. But I'm guessing I will be old enough to turn in my driver's license out of prudence regarding eyesight and reflexes before I trust a car to drive for me.

But IF the downside to complete automation in a particular case is limited to an annoyance rather than an expensive delay in urgent services, it may well be that yielding control and only intervening if there is an event is the least expensive way to deliver service.

In some other cases never being truly horrible and the extra cost of engineering and implementing operational procedures to do that instead of relying on the maximum vendor supplied automation is justified.

All of which is my long winded way of saying: 1) You're both right some of the time. 2) drumroll.... really ..... "It depends."

mwf

PS: Lothar is that "Dancing in the moonlight" or "Dance with the devil in the pale moonlight" or some Druid ritual?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Sunday, September 22, 2019 11:14 AM To: oracle-l_at_freelists.org
Subject: Re: Best course to understand why a bad plan is chosen by optimizer

On 9/22/19 10:54 AM, Lothar Flatz wrote:

> You should have done all off that at midnight in a full moon night.
> I have terribly good results with that.

In the "good old times" I was banned for posting crap like this. I doubt that you will be banned and that's good. Freedom of speech is a value that I strongly support, even if it means granting you the right to post BS.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l&data=02%7C01%7Cclay.jackson%40quest.com%7C61a31801304f442c91ac08d7403837e4%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637048482507127274&sdata=eopnkvDhLBRsp9HMIK3xT3rqhwMPMPLzijqvA698dFc%3D&reserved=0




--
https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l&data=02%7C01%7Cclay.jackson%40quest.com%7C61a31801304f442c91ac08d7403837e4%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637048482507127274&sdata=eopnkvDhLBRsp9HMIK3xT3rqhwMPMPLzijqvA698dFc%3D&reserved=0


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