<div>
<a href="http://www.databasejournal.com/features/oracle/article.php/3375351" rel="ugc">http://www.databasejournal.com/features/oracle/article.php/3375351</a><br />
<a href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2615558696064" rel="ugc nofollow">http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2615558696064</a>
</div>


http://www.databasejournal.com/features/oracle/article.php/3375351 [http://www.databasejournal.com/features/oracle/article.php/3375351]
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2615558696064 [http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2615558696064]

<div>
<div class="content wysiwyg-content">
Is there a view or table in Oracle 8i that records the SQL command/procedure/package etc that a user is currently running. I can get this info using TOAD or another similar package but I also need to know how to select this data using an sqlplus command.<br />
<br />
Can anyone assist ?<br />
<br />
Many thanks.<br />
<br />
Matthew.
</div>
</div>


Is there a view or table in Oracle 8i that records the SQL command/procedure/package etc that a user is currently running. I can get this info using TOAD or another similar package but I also need to know how to select this data using an sqlplus command.

Can anyone assist ?

Many thanks.

Matthew.

Which view or table in Oracle 8i contains the SQL command being run.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.