What is Water Mark in Oracle?

Answer Posted / nithya

High water mark(hwm) indicates the max level to
which the data has risen in the table. when data is inserted
in the table hwm is adjusted accordingly, If all data is
deleted in a table, hwm is not adjusted and remains pointing
to the max data position in the table.

Is This Answer Correct ?    22 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Whats the benefit of dbms_stats over analyze?

1483


What is data file?

600


What is an oracle database table?

579


What are the differences between blob and clob in oracle?

569


how may join possible between (requisition with purchase order)

1686






What are the different types of database objects?

513


Explain the use of analyse option in exp command.

582


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

598


Explain rename?

530


What is a Garbage Collection? and what is full recursive Garbage collection?

2377


What are the built-in functions used for sending Parameters to forms ?

2829


How can we force the database to use the user specified rollback segment?

548


Hi Can any one tell me what are the API's used in requisition import.

1471


How to grant create session privilege to a user in oracle?

552


Is there an oracle sql query that aggregates multiple rows into one row?

530