OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » user access

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

user access [message #53140]

Thu, 29 August 2002 00:49

andy
Messages: 92
Registered: December 1999

Member

is there a way to establish how many users are accessing the system, to establish licensing requirements ?

Report message to a moderator

Re: user access [message #53145 is a reply to message #53140]

Thu, 29 August 2002 04:59

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

list of the users, and count of conections per user
SQL> ed
Wrote file afiedt.buf

  1  select username,count(username) from v$session
  2* group by username
SQL> /

USERNAME                       COUNT(USERNAME)
------------------------------ ---------------
LAWSON                                      10
TRICORE                                      1
                                             0

Report message to a moderator

Re: user access [message #53154 is a reply to message #53145]

Thu, 29 August 2002 07:06

AndyM
Messages: 2
Registered: August 2002

Junior Member

thanks

Report message to a moderator

Re: user access [message #53171 is a reply to message #53140]

Fri, 30 August 2002 09:24

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

Number of users accessing the system can also be found from the alert log.

Whent the database is recycled, there is an entry for high water mark from the period the datbase coming up till going down. Please note that this is written ONLY when the database is shutting down.

Look for somrthing like 'License high water mark = 88'.

NOTE: This is the highest number of CONCURRENT users in the system at any time and NOT the total no of users connected to the system.

Good luck.

Report message to a moderator

Previous Topic:	ORA-1652: unable to extend temp segment by 7680 in tablespace
Next Topic:	Re: The "Oracle OEM Management Server" Services do not START!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 08:15:12 CST 2025