Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: User Query Tools

From: Jared Still <>
Date: Mon, 10 Sep 2001 19:17:16 -0700
Message-ID: <>

There are products that can be used to enforce what kind of queries run on your database.

Very expenive, lot's of setup. Some of you may still be interested though.


On Monday 10 September 2001 17:40, Charlie Mengler wrote:
> 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: Jared Still

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 - 21:17:16 CDT

Original text of this message