DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How can I see how many they had been connected in the database?????

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Unhappy How can I see how many they had been connected in the database?????

    How I can make to see how many they had been connected in the
    database in the finish day, separating the normal users of the users of connection pool?


    Tks

    Hiran

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hmm what are you talking about

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    I'd love to help this guy but I don't have my tinfoil to chew on.

    I honestly sat here for about 10 minutes trying to decifer this question. Yes, I'm bored.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  4. #4
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    Okay people, I'm getting creative here, taking liberties, guessing and some free association:

    1. It's the end of the day (say 5:00) and I want to know how many connections are shared versus pooled

    select server, count(*)
    from v$session
    group by server

    - OR -

    2, It's the end of the day (say 5:00) and I want to know how many connections TOTAL there were for the day

    CREATE OR REPLACE TRIGGER system_logon_trigger
    AFTER LOGON ON system.schema
    DECLARE
    --
    BEGIN
    -- ***Pysdo code *******
    -- This is a schema logon trigger. Look in the docs to see if there is a database
    -- wide login trigger or else you need this schema logon trigger for each schema (pretty terrible)
    --
    -- IF v$session.server = 'DEDICATED' THEN
    -- Increment a dedicated sequence
    -- IF v$session.server = 'POOLED' THEN -- whatever the value is for ConnPool
    -- Increment a pooled sequence
    --
    END;

    At the 'end of the day'
    add up the sequences and reset the sequences for the next day

  5. #5
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114
    Mr. GOPI.

    Correct, grateful Mr. this for its atention.

    Anothers

    Tanks too for you atention.

  6. #6
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    I wonder if it would do this place any good to have other forums in different languages and have people who are fluent in those languages moderate it?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  7. #7
    Join Date
    Aug 2002
    Posts
    17
    I don't think that's a good idea.

    The problems and solutions are common to all of us.
    We need to see as many solutions as possible.

    At least two of us understood him, and he is getting practice expressing in English.

  8. #8
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    sigh I guess you're right.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

Posting Permissions

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


Click Here to Expand Forum to Full Width