Re: Show executing sql command

From: Troy Meyerink <meyerink_at_usgs.gov>
Date: Fri, 29 Dec 2000 19:20:38 GMT
Message-ID: <3A4CE406.70267063@usgs.gov>

Mel,

You can see the current sql statements running by querying the v$session, v$process, and v$sqltext tables joined by addresses. If you are running OEM you can use the Top Sessions manager.

Troy Meyerink
Oracle DBA
Raytheon
USGS EROS Data Center

mel_at_news_at_my-deja.com wrote:

> Hi Folks,
>
> I have 6000 generated sql update statements. Is
> there a set command or such, which will display
> the currently executing sql command, to allow me
> to keep track of where we are?
>
> Thanks
>
> Mel
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Dec 29 2000 - 13:20:38 CST