What is Water Mark in Oracle?

Answer Posted / bikash khuntia

High watermark means, the largest amouth of data
that was placed in a table. for example, Let's say
you created a table and inserted 100 records, and then
added 1000 records more. Now the table highwater mark is
the 1000 record. Now let's say you deleted all the
records in that table using the 'delete' command. Now
your highwater mark for the table still sits at the 1000
record . Though after the delete you have no records
in the table, when a query is performed on this empty
table, it will still scan upto the 1000 highwater mark,
So even with no records, the query will still take
sometime returning because it scans up to the high
watermark.

Now, instead of deleating the records with delete command,
You trucate the tabel, Truncate will remove the high
watermark for the table, and now on an empty table the
query is faster due to the high watermark being gone

Is This Answer Correct ?    21 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4908


Can a parameter be passed to a cursor?

577


How to join two tables in a single query using oracle?

542


What are the different types of trigger and explain its various uses and functions?

521


What are the benefits of ordbms?

591






Explain oracle instance.

660


How to use null as conditions in oracle?

557


What is the data pump import utility?

564


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1635


Explain user account with reference to oracle.

514


How to initialize variables with default values?

609


How to store only time; not date and time?

540


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1547


Is a rollback possible to any savepoint?

542


What is blob datatype?

545