GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Database  >  Database Admin
Go To First  |  Previous Question  |  Next Question 
 Database Admin  |  Question 62 of 69    Print  
High Water Mark
What is High Water Mark in Oracle?


  
Total Answers and Comments: 1 Last Update: February 10, 2009     Asked by: krishnaprasad.sola 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: DPsireesha
 

The High Watermark is the maximum fill-grade a table has ever reached. The
blocks above high water mark are empty blocks.

Initially when you create a table the high water mark is the first block. When
you insert rows on the table the high water mark increases step by step.


The high water mark will not be changed when you delete the rows.

For example If you insert 1000 rows in a table and deletes 500 rows then the
High water mark will stay at the level of 1000 rows.



Above answer was rated as good by the following members:
raghukothur
February 24, 2009 08:43:13   #1  
DPsireesha Member Since: February 2009   Contribution: 2    

RE: High Water Mark

The High Watermark is the maximum fill-grade a table has ever reached. The
blocks above high water mark are empty blocks.

Initially when you create a table the high water mark is the first block. When
you insert rows on the table the high water mark increases step by step.


The high water mark will not be changed when you delete the rows.

For example If you insert 1000 rows in a table and deletes 500 rows then the
High water mark will stay at the level of 1000 rows.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    

 Related Questions

What is High Water Mark in Oracle? 
Latest Answer : The High Watermark is the maximum fill-grade a table has ever reached. The blocks above high water mark are empty blocks.Initially when you create a table the high water mark is the first block. When you insert rows on the table the high water mark increases ...


 Sponsored Links

 
Related Articles

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

Performing XSLT Transformations inside the Database

Performing XSLT Transformations inside the Database Now that you have the employees XSL stylesheet stored in the database and the xmlusr schema is permitted to access the hr employees table you can create a script that will instruct the database to build an HTML page based on the data stored in hr e
 

Moving All the XML Processing into the Database

Moving All the XML Processing into the Database In the preceding example the database server performs only a part of the XML processing while the rest is still performed by the PHP engine Specifically the database server generates an employees XML document based on the records from the hr employees
 

Performing XML Processing inside the Database

Performing XML Processing inside the Database When building XML enabled applications on top of Oracle there are many advantages to performing the XML processing inside the database when compared to performing it on the client The key advantages to perform XML processing inside the database are as fo
 

High Level Data Link Control (HDLC)

High Level Data Link Control HDLC The High Level Data Link Control protocol was developed by the International Organization for Standardization ISO It is used for switched and non switched networks and is a bit oriented architecture The High Level Data Link Control has been accepted and used widel
 

High-Speed Serial Interface (HSSI)

High Speed Serial Interface HSSI HSSI is High Speed Serial Interface was first developed by Cisco systems and the main purpose was to solve high speed requirement issues The main application of HSSI is on the Wide Area Networks and it helps to enhance the data flow speed on these networks It can wor
 

Why your Supply Chain Costs are too High

Why your Supply Chain Costs are too High If you ask most business owners if reducing their costs is important they won’ t hesitate to answer Why yes of course But when it comes to reducing their supply chain costs many of these same business owners have no clue what to do or even where
 

What is Operational Database

Operational Database is the database-of-record, consisting of system-specific reference data and event data belonging to a transaction-update system. It may also contain system control data such as indicators, flags, and counters. The operational database is the source of data for the data warehouse
 

Evolution of database systems

The Evolution of Database systems File Management System Hierarchical database System  Network Database System  Relational Database System File Management System: The file management system also called as FMS in short is one in which all data is stored on a singl
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape