OraFAQ Forum: Performance Tuning » How many connection are on line

Home » RDBMS Server » Performance Tuning » How many connection are on line

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many connection are on line [message #266590]

Tue, 11 September 2007 03:29

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!

Report message to a moderator

Re: How many connection are on line [message #266591 is a reply to message #266590]

Tue, 11 September 2007 03:30

alexia_net
Messages: 25
Registered: August 2007

Junior Member

I am using Windows 2003 server. The oracle version is oracle 92.

Report message to a moderator

Re: How many connection are on line [message #266595 is a reply to message #266590]

Tue, 11 September 2007 03:36

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Do you mean session?

 select count(*) from v$session;

Report message to a moderator

Re: How many connection are on line [message #266620 is a reply to message #266595]

Tue, 11 September 2007 04:17

alexia_net
Messages: 25
Registered: August 2007

Junior Member

Yes thats it. Thank you!

Report message to a moderator

Previous Topic:	CPU usage has been 100% consistently
Next Topic:	a lot of rollback problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 03 04:42:27 CDT 2025