Suppose I have a code which SELECTs from two different tables ( One table T1 has 177 million records and T records) and then INSERTs into another (3rd) table.It is been running for 12 hours and I want to know what is happening?This series of tutorials concentrates on combining SQL with SQL contains a number of keywords such as SELECT, DELETE, UPDATE, FROM, WHERE, OR, AND, DISTINCT and many others.SQL keywords are usually combined with arguments in the form of table names, field names, criteria etc. An SQL statement may contain one or more clauses such as a WHERE clause (containing the criteria of a query) or an ORDER BY clause (determining the order in which a query's data is displayed).','
As to SQL statemets, I can join v$session.user# with v$sqlarea.parsing_user_id ( am I really right ??? How can I track the execution of those objects and queries (something like V$transaction for entire trasactions) ? If someone is executing PLSQL, what you will see will depend on what the plsql is currently doing. if the plsql is doing lots of PLSQL work -- you'll see that code.