How to find Max sessions ever reached by the database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: How to find Max sessions ever reached by the database

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,

    Is there a way where we can find the maximum number of sessions ever reached by the database.

    Something like a High water mark for number of sessions.

    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    select * from v$resource_limit
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    If you mean during a given session, then look at the alert log after a shutdown normal. It will show max sessions. I don't know where it is stored internally.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Ever reached in the current instance vs ever reached ever?

    v$whatever view is only good for the current instance. Alert log, as mentioned, is an alternative.

  5. #5
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Thanks for the input on v$resource_limit. I looked, I thought for all MAX_ fields and it did not show up.

    Interesting.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  6. #6
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  7. #7
    Join Date
    Jun 2002
    Posts
    15
    You can also use auditing to audit the number of connections made take a look in the admin manual. Just make sure AUD$ doesn't get to big by deleting info that is say three months out of date from it. AUD$ is in the SYSTEM tablespace after all.

    Although you can also move AUD$ to another tablespace this is supported by Oracle.

  8. #8
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by TimHall
    Sounds like you need v$license :

    http://otn.oracle.com/docs/products/...ch377.htm#5370
    I am looking for the maximum number of sessions reached since the database has been created, not since the instance started.

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  9. #9
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Originally posted by jrpm
    Thanks for the input on v$resource_limit. I looked, I thought for all MAX_ fields and it did not show up.

    Interesting.
    Doesn't it show MAX_UTILIZATION col?

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  10. #10
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Probably you cannot find it unless you start tracking the sessions programatically.
    Sridhar R Patnam

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