RE: Oracle Reports....

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 26 Oct 2001 02:20:26 -0700
Message-ID: <F001.003B5717.20011026022018@fatcity.com>

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:

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" <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).
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
  INET: raj.gopalan_at_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_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).
--
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_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_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 Fri Oct 26 2001 - 04:20:26 CDT