Re: Monitor Queries

From: <yong321_at_yahoo.com>
Date: Mon, 07 Feb 2000 05:03:41 GMT
Message-ID: <87ljnb$sps$1@nnrp1.deja.com>

In article <0030fc2d.4a2e031f_at_usw-ex0102-013.remarq.com>, Mario Bucsics <mario.bucsicsNOmaSPAM_at_siemens.at.invalid> wrote:
>
> Just query the table v$sqlarea or v$source.

I think you meant dba_source. But I don't think dba_source is of much help here. Or you meant v$sqltext, which is the same as v$sqlarea in terms of the sql_text colunm?

--
Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Feb 06 2000 - 23:03:41 CST