Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: viewing users sql

Re: viewing users sql

From: Joel Garry <joel-garry_at_home.com>
Date: 31 Dec 2003 15:43:46 -0800
Message-ID: <91884734.0312311543.3fce4c67@posting.google.com>


zipper59er_at_yahoo.com (chet) wrote in message news:<3988d00.0312292131.969fbe3_at_posting.google.com>...
> I would like to see all sql issued by a user for a currently open
> session. Is there a way to do this?
> -thank you

Look at top sessions with OEM. You can drill to the explain plan that way, too.

jg

--
@home.com is bogus.
http://www.netfunny.com/rhf/jokes/90q1/santa.1082.html
Received on Wed Dec 31 2003 - 17:43:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US