Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Execution status check

Re: SQL Execution status check

From: Robert Ottohall <rob_at_ohall.com>
Date: Tue, 6 Oct 1998 08:45:02 +0200
Message-ID: <6vcecr$2fs$1@goof.de.uu.net>


log in as system,
there are the V$... Views
try this:

select sql_text from V$OPEN_CURSOR;

OR this which shows you the last exectuted sql statements:

select sql_text from V$sql

Regards Rob

Ritu Raj wrote in message <6vc82k$lsi_at_world1.bellatlantic.net>...
>
>Hello everyone,
>
>I am running Oracle 7.3.2 on a Sequent/ptx environment. Is there any
>way to check what SQLs are being executed on the database server from
>UNIX or SQL command line?
>
>Thanks for any help in this area.
>--
> _==_ Ritu Raj (mailto:rajr_at_nasd.com)
> ( "> Senior Software Engineer, Market Data Server
> (> )> The Nasdaq Stock Market
> ^^ (301)590-6115 / (888)559-4679
Received on Tue Oct 06 1998 - 01:45:02 CDT

Original text of this message

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