OraFAQ Forum: Server Administration » max concurrent sessions connected

Home » RDBMS Server » Server Administration » max concurrent sessions connected

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

max concurrent sessions connected [message #334198]

Tue, 15 July 2008 15:36

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
How to get maximum concurrent session that were connected in my database in previous days?

Report message to a moderator

Re: max concurrent sessions connected [message #334200 is a reply to message #334198]

Tue, 15 July 2008 15:48

BlackSwan
Messages: 26766
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%'

Report message to a moderator

Re: max concurrent sessions connected [message #334203 is a reply to message #334198]

Tue, 15 July 2008 15:50

caprikar
Messages: 226
Registered: March 2007

Senior Member

BTW, its oracle 10gR2 in HPUX

Report message to a moderator

Re: max concurrent sessions connected [message #334217 is a reply to message #334198]

Tue, 15 July 2008 22:14

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:52:11 CST 2024