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: Monitoring SQL statements in oracle

Re: Monitoring SQL statements in oracle

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 21 Jan 2004 23:19:59 +0100
Message-ID: <alut001v5sb4br9r4l2c4594hqh3i9g8dh@4ax.com> 





On 21 Jan 2004 13:08:21 -0800, ertan_c_at_excite.com (Ertan) wrote:



>I'm trying to monitor "erroneous" SQL statements issued by an

>application. Is there a way to do this?

>

>Ertan




Yes



v$sql has various statistics concerning resource consumption
the address and hash_value columns can be joined to sql_address and
sql_hash_value to find offending sessions.



--
Sybrand Bakker, Senior Oracle DBA


Received on Wed Jan 21 2004 - 16:19:59 CST












Original text of this message













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