check the number of open connection in oracle8
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: check the number of open connection in oracle8

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    5

    Thumbs up

    Hi guys ,

    I ned to find out the number of open connections in oracle .how can i find it out .is there any views storing these daats .

    thanks and regards
    Rajeev Aikkara

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    I think you are talkin about number of sessions then look at v$session

    Cheers

    Angel

  3. #3
    Join Date
    Apr 2002
    Posts
    7
    On UNIX or LINUX you can see process too !
    Gaulard Cyrille
    COMCLICK

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Main question is: WHAT KIND OF CONNECTION U NEED?
    -------------------------------------------
    I oracle applications we may have several kinds of connections.

    If database works in dedicated mode then connections to database ~ sessions
    If database works in MTS mode then not, #of client connections not equal
    (as a rule) # of sessions
    If ur application use same EXTERNAL CONNECTION POOL (for example with MTS)
    then u never know exactly how many real connections u have.
    -----------------------------------------
    Can u a little bit explain ur question?

  5. #5
    Join Date
    Mar 2002
    Posts
    5

    Smile open connection in oracle8


    i will explain the full scenario .


    i have oracle 8i as my back end .now i need to know how many connection are actually opened by my connection pool manager when i am accessing the database through my front end application.Will the number of sessions be equal to the number of connections ,i guess it should ,but i need to confirm .

    rajeev


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