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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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).

Reply via email to