Results 1 to 4 of 4

Thread: Database query

  1. #1
    Join Date
    Jul 2004
    Posts
    40

    Question Unanswered: Database query

    Dear All,

    I want to know, is there any query to find out the instances currently used by applications(currently occupied) ?.

    Cheers
    Kamesh.

  2. #2
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    Code:
    select * From Global_name;

  3. #3
    Join Date
    Jul 2004
    Posts
    40
    Hi DKG,

    This command gives the connect string of the oracle. But I want to know the list of users are being used by the applications. Hope I am clear.


    Kamesh.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The query

    Code:
    select distinct username from v$session
    where username is not null;
    will return a distinct list of the users connected to the database. Is that what you want?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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