Re: How to monitor active SQL queries in JDBC connections?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 02 Jul 2002 18:07:32 +0100
Message-ID: <3D21DDD4.3AE4@yahoo.com>

peter.peltonen_at_iki.fi wrote:
>
> We want to monitor currently executing SQL queries in each JDBC
> connection.
>
> Is there a way to do this?
>
> We are running Oracle 9iR1 on Red Hat Linux 7.2.
>
> Regards,
> Peter

From the database you look at v$session for status = 'active' and use the sql_address to find the sql text in v$sql, v$sqltext, v$sql_plan et al.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Tue Jul 02 2002 - 12:07:32 CDT