Re: I need to vent
Date: Tue, 1 Mar 2016 11:11:20 -0600
Message-ID: <CAHSa0M0qjsb2NJu4s-penPejTuaU7u8DG9gLPM4VTx2_qna_XQ_at_mail.gmail.com>
Is there any such thing as the limit on the number of characters or lines for a SQL statement?
How much is the parse time? and how much memory does this take in the shared pool?
On Tue, Mar 1, 2016 at 10:51 AM, Matt Adams <MAdams_at_troversolutions.com> wrote:
> 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. ****
>
-- -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 01 2016 - 18:11:20 CET