Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: User Query Tools

Re: User Query Tools

From: Charlie Mengler <>
Date: Mon, 10 Sep 2001 16:28:28 -0700
Message-ID: <>

Just be prepared to watch response time for honest OLTP work to increase through the roof.
Almost daily I have adhoc query folks throw onto the DB a "query from hades" which
result in 3 - 6 way cartesian joins of tables with hundred of millions of rows EACH.
When the first query does not return results "fast enough" they tweak the query and
launch yet another. We are taking steps to ban ALL adhoc queries from our OLTP
system before the end of this year.

May the force be with you!

Stephen Andert wrote:

> Hey all, I just got out from a meeting where I was told that some of
> our users are asking for a tool to do their own queries against our
> database so they wouldn't have to request reports and such from IS.
> Oh BTW, they don't know (or feel the need to learn) SQL so they will
> be needing something with either a good GUI QBF or some kind of
> natural language interface. We are leaning against MS Query to avoid
> ODBC performance problems. Does anyone out there have users like
> this? Any product referrals with pros/cons? TIA If you have any
> questions, please feel free to call me or drop me a note. Stephen
> Andert
> 480-445-2506

Please see the official ORACLE-L FAQ:
Author: Charlie Mengler

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 10 2001 - 18:28:28 CDT

Original text of this message