What is WATER MARK IN oracle? - oracle

What is WATER MARK IN oracle? Explain the significance of High water mark.

WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once contained some data. This data might have been deleted later. Oracle knows that blocks beyond high WATER MARK don’t have data; it only reads blocks up to the high WATER MARK during a full table scan.
What is an object groups? - oracle
What is an object groups? - Object group is a container for a group of objects....
Difference between clustering and mirroring - oracle
Difference between clustering and mirroring - Clustering means one than one database server configured for the same user connection. When users connect, one of the server’s responds...
Difference between paging and fragmentation - oracle
Difference between paging and fragmentation - Paging is a concept occurring in memory, whereas, Fragmentation occurs on disk level...
Post your comment