Lol !! Matt, it must be an application. Back when one of the applications
DB's was Seibel, we used to have situations like these. We would spend
cycles debugging "slow" stuff, and we would end up with a SQL that we cant
modify as it's application generated. Oracle iStore does something similar.
I hear your pain, and would like to know the app that generated the 500
page novel.
On 01-Mar-2016 9:27 PM, "Matt Adams" <MAdams@xxxxxxxxxxxxxxxxxxx> wrote:
1.8 million characters!!!!! How in bloody hell does ANYTHING write a
single sql statement that 1.8 million characters long.
Just for fun, I pasted it into microsoft word….ITS OVER 500 PAGES. It’s a
freaking novel!!
It’s a mass of nested selects (I quit counting at six levels deep) and
massive numbers of unions. It optimizer must have lost its mind trying to
figure this one out.
I’ve never seen anything quite like it. This may be the most obscene
thing I’ve ever seen in 23 years as an oracle dba.
I can’t imagine someone actually writing this monstrosity. It must have
been generated by some application at run time.
And I’ve just been asked to troubleshoot why this statement takes so
long…hmm….can’t imagine a single reason.
I just needed to vent a little to somebody who might understand. What’s
the most egregious statement you’ve come across?
We now return you to your regularly scheduled helpful oracle related mail
list.
Matt
**** 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. ****
