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: User's running command

Re: User's running command

From: Janos Makadi <maki_at_freemail.hu>
Date: Fri, 25 Jun 2004 17:40:03 GMT
Message-ID: <TrZCc.125509$vP.69422@news.chello.at>


Michel Cadot wrote:
> Sorry last line is:
> and v$session.sql_hash_value=v$sqlarea.hash_value;

It works great. Thanks again.

I found how to set up oracle server to trace a single connected session`s sql statements. My only problem is, trace, and v$sqlarea only shows faultless querys.

Is it a way to trace querys end with an error?

THX Janos Makadi Received on Fri Jun 25 2004 - 12:40:03 CDT

Original text of this message

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