Home » RDBMS Server » Performance Tuning » How many connection are on line
How many connection are on line [message #266590] Tue, 11 September 2007 03:29 Go to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Hi. Is it possible to see how many connection are on at some point? I want ot check because sometimes I get this message "cannot create connection using schema...". I have increased to number of connections from 250 to 500, but I still have this problem. Any idea why? Thank you!
Re: How many connection are on line [message #266591 is a reply to message #266590] Tue, 11 September 2007 03:30 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
I am using Windows 2003 server. The oracle version is oracle 92.
Re: How many connection are on line [message #266595 is a reply to message #266590] Tue, 11 September 2007 03:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Do you mean session?
 select count(*) from v$session;

Re: How many connection are on line [message #266620 is a reply to message #266595] Tue, 11 September 2007 04:17 Go to previous message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Yes thats it. Thank you!
Previous Topic: CPU usage has been 100% consistently
Next Topic: a lot of rollback problem
Goto Forum:
  


Current Time: Sat Dec 03 05:41:26 CST 2016

Total time taken to generate the page: 0.07979 seconds