Results 1 to 3 of 3

Thread: capture active connection's sql command

  1. #1
    Join Date
    Sep 2002
    Posts
    5,938

    capture active connection's sql command

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try V$SQL and V$SQLAREA

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    I try to check if any dbms_stats.gather_schema_stats process running, they are not listed in those two views.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •