Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is Water Mark in Oracle?

Answers were Sorted based on User's Feedback



What is Water Mark in Oracle?..

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 ?    22 Yes 1 No

What is Water Mark in Oracle?..

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 ?    15 Yes 0 No

What is Water Mark in Oracle?..

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

What is Water Mark in Oracle?..

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

What is Water Mark in Oracle?..

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

What is Water Mark in Oracle?..

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 Water Mark in Oracle?..

Answer / cmahesh

water's use is to drink

Is This Answer Correct ?    3 Yes 10 No

Post New Answer



More Oracle General Interview Questions

How to delete multiple rows from a table in oracle?

0 Answers  


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

0 Answers  


diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,


What is query image?

0 Answers  


What are the system predefined user roles?

0 Answers  






What are named parameters?

0 Answers  


What is a cluster?

2 Answers  


"primary key=unique+null" is equal,reson?not,reason?

5 Answers  


What is a tns service name?

0 Answers  


What suggestions do you have to reduce the network traffic?

0 Answers  


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,


Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)