Home » RDBMS Server » Server Administration » High Water Mark
High Water Mark [message #226071] Thu, 22 March 2007 08:04 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi.

What is high water mark in oracle? please explain me with simple example and also explain now to avoid that?

Thanks,
Shahnaz.
Re: High Water Mark [message #226090 is a reply to message #226071] Thu, 22 March 2007 08:27 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Look at http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-09-10.8045550726
Re: High Water Mark [message #226093 is a reply to message #226071] Thu, 22 March 2007 09:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just to add,
SEARCH the forum before posting.
This question is been asked and answered too many times.
Re: High Water Mark [message #226383 is a reply to message #226093] Fri, 23 March 2007 08:13 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi Michael,
Thanks for that link, i don't have access to metalink. could you please brief how to calculate HWM.

Thanks,
Shahnaz.
Re: High Water Mark [message #226426 is a reply to message #226383] Fri, 23 March 2007 11:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I hate to pick on people. But you give me no choice Smile
As asked before, SEARCH BEFORE POSTING.
One such is
http://www.orafaq.com/forum/m/222603/42800/?srch=find+hwm#msg_222563
Re: High Water Mark [message #227311 is a reply to message #226426] Tue, 27 March 2007 23:39 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi Mahesh,
thanks for this link.

From the link i learned how to calculate HWM, how to delete the same?

Thanks,
Shahnaz.
Re: High Water Mark [message #227313 is a reply to message #226071] Tue, 27 March 2007 23:41 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
TRUNCATE TABLE
Re: High Water Mark [message #227491 is a reply to message #227311] Wed, 28 March 2007 06:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you even bother to read/understand what we are trying to say?
SEARCH the forum!!!!!.
Most of the questions asked are already answered again and again.
Re: High Water Mark [message #227738 is a reply to message #227491] Thu, 29 March 2007 04:11 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi Mahesh,
I am just novice in DBA, i searched ready regarding this. But i don't find any which talks about how to remove HWM? clearly me if iam wrong.

Thanks,
Shahnaz.
Re: High Water Mark [message #227754 is a reply to message #227738] Thu, 29 March 2007 05:06 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You claim NONE of these deal with HWM?
Being novice has nothing to do with this.
It is just your willingness to throw some effort!.
Infact the links i posted above also talks about it

http://www.orafaq.com/forum/?SQ=fd9687d5ca38f8edd34165f1663db8ac&t=search&srch=reset+HWM&btn_submit=Search&field=all& amp;forum_limiter=&search_logic=AND&sort_order=DESC&author=
Previous Topic: Oracle and Windows Clusters
Next Topic: How to Find out,.what install i have in my system and how to clean the installation
Goto Forum:
  


Current Time: Sat Dec 03 14:18:36 CST 2016

Total time taken to generate the page: 0.11795 seconds