Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Execution status check
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