What is Water Mark in Oracle?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is hot backup and logical backup?

594


What are the differences between primary key and unique key?

506


How to join two tables in a single query using oracle?

558


How can I create database in oracle?

557


What are the different oracle database objects?

577






Is java required for oracle client?

540


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1449


Explain an index?

654


How to insert a record into a table?

628


How many types of database triggers exist?

562


Explain the use of consistent option in exp command.

544


definition of cluster and non-clustered index?

2468


What is varray?

578


Explain about your project and its relation to the current job position you are applying to?

531


How to execute a stored program unit?

576