Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Barcelona
    Posts
    32

    Question Unanswered: number of connections

    How can I know the number of open connections to a database from a client application (via ADO)?

  2. #2
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    If you have the privileges you may try to query

    select * from v$session;


    Try describe it: there are a number of interesting fields to give you information on who is doing what in your db.

    hope this helps
    astropp

Posting Permissions

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