Re: Explain plan on another users SQL

You can trace other user's session with
'dbms_system.set_sql_trace_in_session'.
It creates trace file, which should be processed with 'tkprof'. Resulting file will include 'explain plan'.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com

• Original Message ----- From: "Williams, Leighton" <leighton.williams_at_uk.fid-intl.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 17, 2000 10:41 AM Subject: Explain plan on another users SQL

> Is there a method of running explain plan on SQL that another user may be
> running currently?
>
> I know it can be done from topsessions with details...cursors...explain
> plan, just want to know if there's a method from within SQL*PLUS?
>
> Regards
>
> Leighton Williams
> Technical Services
>
> --
> Author: Williams, Leighton
> INET: leighton.williams_at_uk.fid-intl.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 Wed May 17 2000 - 12:25:52 CDT