you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext
- "Thomas, Kevin" <Kevin.Thomas_at_calanais.com> wrote:
> Hi all,
>
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
>
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
>
> Any thoughts guru-type-people ;o)
>
> Kev.
>
> "hit any user to continue"
> __________________
>
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Thomas, Kevin
> INET: Kevin.Thomas_at_calanais.com
>
> 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: ListGuru_at_fatcity.com (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).
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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 Thu Oct 25 2001 - 07:39:23 CDT