Home » RDBMS Server » Server Administration » max concurrent sessions connected
max concurrent sessions connected [message #334198] Tue, 15 July 2008 15:36 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
How to get maximum concurrent session that were connected in my database in previous days?
Re: max concurrent sessions connected [message #334200 is a reply to message #334198] Tue, 15 July 2008 15:48 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
does the following provide you any clues?

select table_name, column_name from dba_col_comments where column_name like '%MAX%' and table_name like 'V%'
Re: max concurrent sessions connected [message #334203 is a reply to message #334198] Tue, 15 July 2008 15:50 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
BTW, its oracle 10gR2 in HPUX
Re: max concurrent sessions connected [message #334217 is a reply to message #334198] Tue, 15 July 2008 22:14 Go to previous message
satheeshnagaraj
Messages: 1
Registered: July 2008
Junior Member
Hi,

you need to view v$license(Sessions_highwater) or alert log to get the info. This will give you te max number of concurrent sessions since the instance startup

[Updated on: Tue, 15 July 2008 22:15]

Report message to a moderator

Previous Topic: Oracle DIRECTORY object
Next Topic: auto export while windows is starting
Goto Forum:
  


Current Time: Wed Dec 07 16:26:23 CST 2016

Total time taken to generate the page: 0.09028 seconds