Re: Explain plan on another users SQL

Yes there is. Check out DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION. In my experience it works about half the time.

Lisa

"Williams, Leighton" <leighton.williams_at_uk.fid-intl.com> on 05/17/2000 09:41:50 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

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).