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
Printable View
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
I think you are talkin about number of sessions then look at v$session
Cheers
Angel
On UNIX or LINUX you can see process too !
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?
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