-
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 !
Gaulard Cyrille
COMCLICK
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|