OraFAQ Forum: Server Administration » Maximum concurrent logins

Home » RDBMS Server » Server Administration » Maximum concurrent logins (Oracle 9i / Windows 2000)

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

Maximum concurrent logins [message #531871]

Fri, 18 November 2011 03:24

Boris1234
Messages: 3
Registered: November 2011

Junior Member

Hi,
Need to find out what the maximum number of concurrent logins are over a period of 1 month. We need to do this as we may need to buy more licences.

Any ideas? I'm very much a part time DBA so please simple solutions Smile

Thanjs

Report message to a moderator

Re: Maximum concurrent logins [message #531873 is a reply to message #531871]

Fri, 18 November 2011 03:57

Michel Cadot
Messages: 54691
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at V$LICENSE.SESSIONS_HIGHWATER for the current instance and in alert.log for the history.

Regards
Michel

Report message to a moderator

Re: Maximum concurrent logins [message #531883 is a reply to message #531873]

Fri, 18 November 2011 04:36

Boris1234
Messages: 3
Registered: November 2011

Junior Member

Thanks for the info regarding v$license. Where do I find the number of purchased licenses?

Report message to a moderator

Re: Maximum concurrent logins [message #531884 is a reply to message #531883]

Fri, 18 November 2011 04:48

Michel Cadot
Messages: 54691
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In SESSIONS_MAX column... if you set it using license_max_sessions, license_max_users parameters.

Regards
Michel

Report message to a moderator

Re: Maximum concurrent logins [message #531885 is a reply to message #531884]

Fri, 18 November 2011 04:49

Boris1234
Messages: 3
Registered: November 2011

Junior Member

Great, thanks for your help.

Regards
Dave

Report message to a moderator

Previous Topic:	calculate used space in a block
Next Topic:	Fractured block during buffer read

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 04:12:35 CDT 2013

Total time taken to generate the page: 0.24026 seconds