RE: I need to vent

From: TJ Kiernan <tkiernan_at_pti-nps.com>
Date: Tue, 1 Mar 2016 17:24:46 +0000
Message-ID: <196DB2D4BDE5804EAF3158CCC1C698BC8C035AA8_at_lopez.pti-nps.com>

I hope this is obvious to everyone here, but this is a perfect opportunity to exercise "tune the question."

With something of this magnitude, there are probably multiple layers of people who don't understand what they're asking and/or why they're asking it.

The tools available to us as DBAs (tracing, GATHER_PLAN_STATISTICS hints, SQL Monitoring, etc can tell us where the time is going, but knowing the question being asked of the data is difficult to reverse engineer with a page of well-formatted SQL, let alone 500 of them (not that I expect that this is well-formatted).

When presented with, "Tune my ugly SQL" that's a fraction as ugly, my response is, "Stop running queries and start considering what you want to know." Talk it out. It's nearly certain that it doesn't need to be so bad.

Thanks,
T. J.
 
The information contained in this message is privileged and confidential information intended only for the use of the individual or entity identified above. If the receiver of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, use or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify the sender by replying to his/her e-mail address noted above and delete the original message, including any attachments. Thank you.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Matt Adams Sent: Tuesday, March 01, 2016 10:52 AM
To: John Piwowar
Cc: oracle-l_at_freelists.org
Subject: RE: I need to vent

I've seen queries generated by many different BI tools over the years. Some were bad, some not so much (none were ever great).

But this...this is an order of magnitude worse than anything I've ever seen before.

500 pages for a single statement. I'm still shaking my head in surprise and dismay.

Matt

-----Original Message-----
From: John Piwowar [mailto:jpiwowar_at_gmail.com] Sent: Tuesday, March 01, 2016 11:49 AM
To: Matt Adams
Cc: oracle-l_at_freelists.org
Subject: Re: I need to vent

Exposing DBAs to queries generated by a BI tool without prior warning is so, so cruel. Rest assured, you are not alone in your pain: the number one user requirement for the output of that query is: "please make sure I can export this to Excel." Somewhere, the developer of a whiz-bang data visualization dashboard weeps, adds a menu item, and takes another shot.

Regards,

John P.

On Tue, Mar 1, 2016 at 7:56 AM, Matt Adams <MAdams_at_troversolutions.com> wrote:
> 1.8 million characters!!!!! How in bloody hell does ANYTHING write a
> single sql statement that 1.8 million characters long.
**** This communication may contain privileged and/or confidential information. If you are not the intended recipient, you are hereby notified that disclosing, copying, or distributing of the contents is strictly prohibited. If you have received this message in error, please contact the sender immediately and destroy any copies of this document. **** m  ç¥Š l ? j
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Mar 01 2016 - 18:24:46 CET