High Water Mark.

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 370,604 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,034 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 8981 | Replies: 1

•

Join Date: Mar 2006

Posts: 17

Reputation: shahnazurs is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

shahnazurs shahnazurs is offline

Offline

Newbie Poster

High Water Mark.

Apr 7th, 2006

could you please tell me what is high water mark in oracle terminology? Please explain with example.

•

Join Date: Dec 2006

Posts: 24

Reputation: alit2002 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

alit2002

Offline

Newbie Poster

Re: High Water Mark.

Dec 4th, 2006

Hi

You have to understand Oracle storage.

Each table is made up of extents and each extent is made up of oracle blocks - a common block size is 8k. So you have a table with 10 extents (80K).

You populate your table with 2 million rows of data and you will have many hundreds of extents. Now lets assume that you delete over half of the records in the table. Oracle still has the same number of extents but many of the blocks are empty. When you run a query against the table Oracle will scan through all the blocks including empty ones looking for data. So you can think of the total number of extents / blocks used as the high water mark.

To fix you export the table, drop it and import it back in.

Alistair

Last edited by alit2002 : Dec 4th, 2006 at 7:18 am.