Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    22

    Question Unanswered: Number of concurrent connections open

    I want to know the number of concurrent connections open in oracle at the time I am running my application by each user ?

    Can anyone provide me with the query for the same ?


    thanks in advance.
    AravindD\G

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    select * from v$session where [program|module|client_info etc] = <some identifying feature>

    or....

    where schema = 'myschema'

    However,

    1: it is quite simple to create another user and grant privileges and create synonyms on your schema to bypass user/schema counts.

    2: If your exe is renamed, the 'program' column doesn't work either.

    If it iss licence management you're after, I'm afraid things a are possible but a little more complex.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

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