OraFAQ Forum: Server Administration » Highwater

Home » RDBMS Server » Server Administration » Highwater_Session

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

Highwater_Session [message #55817]

Tue, 18 February 2003 02:00

Jimmy Lim
Messages: 6
Registered: February 2003

Junior Member

Hi,
Anyone know how to adjust the highwater session water mark on Oracle?

Report message to a moderator

Re: Highwater_Session [message #55820 is a reply to message #55817]

Tue, 18 February 2003 05:54

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Select * From V$Rollstat ;

will display the HWMSIZE parameter which is the Current Highwater mark size.. are u talking about shrinking the rollback segments ?

sai

Report message to a moderator

Re: Highwater_Session [message #55827 is a reply to message #55817]

Tue, 18 February 2003 17:38

Jimmy Lim
Messages: 6
Registered: February 2003

Junior Member

Sai,

Sorry for I have confused you. I'm referring the session_highwater and session_current resided within Oracle. This parameter is used to track the number of oracle license used. However, I do not know how to reset the session_highwater parameter. Do you know how can it be done?

Report message to a moderator

Previous Topic:	can u people tell me about oracle physical files
Next Topic:	Drop datafile and not tablespace HELP HELP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 25 17:33:22 CDT 2025