How to list active / open connections in Oracle?

by

Use the V$SESSION view.

V$SESSION displays session information for each current session.

More Related Contents:

  1. Printing the value of a variable in SQL Developer
  2. Oracle Equivalent to MySQL INSERT IGNORE?
  3. null vs empty string in Oracle [duplicate]
  4. Convert comma separated string to array in PL/SQL
  5. UTL_FILE.FOPEN() procedure not accepting path for directory?
  6. Oracle stored procedure with parameters for IN clause
  7. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  8. NLS_NUMERIC_CHARACTERS setting for decimal
  9. Formatting DATE in oracle
  10. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  11. Oracle: How to find out if there is a transaction pending?
  12. Best practice for pagination in Oracle?
  13. check if “it’s a number” function in Oracle
  14. Sql*plus always returns exit code 0?
  15. ORA-12170: TNS:Connect timeout occurred
  16. How to create and use temporary table in oracle stored procedure?
  17. SQL*Plus how to accept text variable from prompt?
  18. How to find difference b/w TIMESTAMP format values in Oracle?
  19. if (select count(column) from table) > 0 then
  20. How to find out when an Oracle table was updated the last time
  21. NLS_LANG setting for JDBC thin driver?
  22. How can I describe a table in Oracle without using the DESCRIBE command?
  23. How to insert a column in a specific position in oracle without dropping and recreating the table?
  24. Get the LENGTH of a LONG RAW
  25. MySQL equivalent of ORACLES rank()
  26. Reading clob line by line with pl\sql
  27. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  28. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  29. How to Register Pluggable Database(PDB) with new created LISTENER
  30. Grant Select on all Tables Owned By Specific User

Leave a Comment