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: 506
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.
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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
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
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: 506
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.?
Re: User statistics [message #430193 is a reply to message #430177] Mon, 09 November 2009 07:07 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Search in AWR views (DBA_HIST...).

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


Current Time: Fri Nov 22 12:32:02 CST 2024