What is Water Mark in Oracle?

Answer Posted / nihar ranjan manadhata

This is a term used with table segments stored in the
database. If you envision a table, for example, as a 'flat'
structure or as a series of blocks laid one after the other
in a line from left to right, the high-water mark (HWM)
would be the rightmost block that ever contained data.

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between open_form and call_form in oracle.

664


Please explain joins in oracle?

541


What do you mean by a tablespace?

556


Difference between inner join vs where ?

598


Can sub procedure/function be called recursively?

525






How do I know if oracle client is installed on windows?

488


How to list all tables in your schema?

595


What is an oracle transaction?

573


Explain the use of inctype option in exp command.

585


What are the differences between interval year to month and interval day to second?

544


Explain coalesce function?

612


What is merge statement used for?

557


How to drop an index?

533


material view and view disadvantages?

624


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1496