Interested to Buy Any Domain ? << Click Here >> for more details...
What is Water Mark in Oracle?
- 7 Answers
- 22795 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 ? | 23 Yes | 1 No |
Answer / 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 |
Answer / raya tharaka ram
The initial position of the high water mark is extent 0
block 0 for tables and extent 0 block 1 for indexes.
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / anks
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 ? | 9 Yes | 6 No |
Answer / firdos kashmiri
High water mark is just a line separates the used blocks and free blocks, the blocks above hwm are free blocks and are ready to use and blocks below hwm are used blocks.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is a Data File ?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Explain the use of tables option in exp command.
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How can I see all tables in oracle?
How to list all indexes in your schema?
What is the relation of a user account and a schema in oracle?
master table and child table performances and comparisons in Oracle ?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is blob datatype?
Oracle General 
