Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Performance Tuning » User statistics (Oracle 10.2.0.4)
User statistics [message #430164] Mon, 09 November 2009 05:31 Go to next message
gkrishn
Messages: 377
Registered: December 2005
Location: Putty a dark screen
Senior Member
 
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit


I found this alert in alertlog.

any idea how to find user statistics for a given time period.i would like to understand how many users where connected,status,how many session from same user id etc... any tips ?i would explore more.
Report message to a moderator
Re: User statistics [message #430174 is a reply to message #430164] Mon, 09 November 2009 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 29435
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
 
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
  *Cause: An attempt was made to exceed the maximum number of
          concurrent sessions allowed by the SESSION_PER_USER clause
          of the user prfile.
  *Action: End one or more concurrent sessions or ask the database
           administrator to increase the SESSION_PER_USER limit of
           the user profile.

Regards
Michel
Report message to a moderator
Re: User statistics [message #430177 is a reply to message #430164] Mon, 09 November 2009 06:33 Go to previous messageGo to next message
gkrishn
Messages: 377
Registered: December 2005
Location: Putty a dark screen
Senior Member
But i donot know for what user it happend.i would like to explore more on this.Any ways to get user statistics for a given period.?
Report message to a moderator
Re: User statistics [message #430193 is a reply to message #430177] Mon, 09 November 2009 07:07 Go to previous message
Michel Cadot
Messages: 29435
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Search in AWR views (DBA_HIST...).

Regards
Michel
Report message to a moderator
Previous Topic:to check for temporary space usage
Next Topic:Does CTAS uses unused space??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 06:16:22 CST 2009

Total time taken to generate the page: 0.20635 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.