Thanks Rachel, I'll check these tables to see what dets they hold. The problem I have is that I can't phone the user and say "are you running that report", because they have a big nasty lady who will come and bite my head off if she thinks we're actually trying to help!!
;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 -----Original Message----- Sent: 25 October 2001 14:35 To: Multiple recipients of list ORACLE-L you should be able to pull the queries out of v$sql, v$sqlarea and/or v$sqltext --- "Thomas, Kevin" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).