Is there any sql plus command to list all active connections with sql statement used? I looked at v$session and v$session_longops, can't find what I want.
Printable View
Is there any sql plus command to list all active connections with sql statement used? I looked at v$session and v$session_longops, can't find what I want.
Try V$SQL and V$SQLAREA
I try to check if any dbms_stats.gather_schema_stats process running, they are not listed in those two views.