Suppose I have a query in my database taking a large mount of memory. Of course I can identify the Unix process ID using ps -ef. It is possible to identify the Oracle user, too.

But, how can I see exactly what that query is doing in a given moment (not Logminer)? Is there a v$ view or something? I know tools like Toad/SQL Navigator have this feature, but don't know how to do with a command line. Any ideas?


thanks in advance.