From Kevin.Thomas@calanais.com Fri, 26 Oct 2001 04:16:53 -0700 From: "Thomas, Kevin" Date: Fri, 26 Oct 2001 04:16:53 -0700 Subject: RE: Oracle Reports.... Message-ID: MIME-Version: 1.0 Content-Type: text/plain Mark, Yip, this sounds like a plan. As I mentioned earlier though, I don't want to awaken the Kracken! So being sneaky and trying to get the reports is key. As they are the client, I don't actually have access to any of there servers that they hold the reports on, or acccess to PVCS (not that I think they would actually have them in PVCS!!). 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: 26 October 2001 11:20 To: Multiple recipients of list ORACLE-L Kevin, Can you not log in as a user yourself and run the reports that you are interested in, then trace your own session to see what SQL is being executed? What I would do: 1) As the report user, run the report you are interested in. 2a) Do a select from v$sqlarea/v$sqltext/v$session to get the SQL for your particular session. 2b) set a SQL trace up for your own session, and record what order you ran the reports in, and try to match this up with the SQL in your trace file. Think this will work? Mark -----Original Message----- Kevin Sent: Friday, October 26, 2001 09:45 To: Multiple recipients of list ORACLE-L Thanks Raj, Part of the problem is we don't know what queries actually belong to which report (because the source is missing) and there are probably about 150+ users of this particular system at anytime running queries from SQL, FORMS or REPORTS. Cheers, 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 19:11 To: Multiple recipients of list ORACLE-L Give a try by tracing the session used by the report. -----Original Message----- Sent: 25 October 2001 16:05 To: Multiple recipients of list ORACLE-L 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" 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@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@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@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: Kevin.Thomas@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: raj.gopalan@netdecisions.co.uk 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: Kevin.Thomas@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark@cool-tools.co.uk 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: Kevin.Thomas@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@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).