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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Matt Adams
Sent: Tuesday, March 01, 2016 10:52 AM
To: John Piwowar
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Tuesday, March 01, 2016 11:49 AM
To: Matt Adams
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx> wrote:
1.8 million characters!!!!! How in bloody hell does ANYTHING write a**** This communication may contain privileged and/or confidential information.
single sql statement that 1.8 million characters long.