Home » RDBMS Server » Server Administration » high wark mark (9i)
high wark mark [message #328944] Mon, 23 June 2008 08:18 Go to next message
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
Junior Member
hi I'm beginner in FUNDA one
I have two questions:
1.any one could explain me wht is high water mark...?? I tried to google out too. but could nt get satisfied answer.

2.and while direct loading "all data that is loaded using direct load insert is loaded above high water mark": what does it mean??
Re: high wark mark [message #328949 is a reply to message #328944] Mon, 23 June 2008 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
FUNDA? What is FUNDA?

Regards
Michel
Re: high wark mark [message #328952 is a reply to message #328949] Mon, 23 June 2008 09:06 Go to previous messageGo to next message
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
Junior Member
Sir I'm studying OCP 9i.
my course fundamentals one has chapter loading ...
Regarding that I have doubts on high water mark
thankx
Re: high wark mark [message #328953 is a reply to message #328944] Mon, 23 June 2008 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://tahiti.oracle.com
contains the whole Oracle Documentation set; with SEARCH capability
Re: high wark mark [message #328955 is a reply to message #328952] Mon, 23 June 2008 09:20 Go to previous messageGo to next message
ssreesraj
Messages: 1
Registered: June 2008
Location: india
Junior Member

(say, u have the last row of a table at location 100th)
high water mark arises when the memory doesnt get relaese or the space doesnt get relaesed off after the deletion of the rows from the table.
(this means u are deleting 50 rows from the table: now the memeory doesnt comes back to 50th position, rather than it in 100th)so while next insertion, the new data get inserted from the original level from the 100th position rather from 50th position , which encounter with performance issuse.

To avoid high water mark ,just move the particular table to another tablespace n vice -versa.

you can now search the google to get the scripts for finding the high water mark.
Re: high wark mark [message #328959 is a reply to message #328955] Mon, 23 June 2008 09:38 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ummmm.......no.

The High Watermark is not related to re-use of deleted space in a table.

The high Water Mark is the last block to be allocated to a table that has had data in it. When Oracle performs a Full Table Scan, it reads all the blocks allocated to the table that have had data in them at some point.
Eg:
You have a large number of rows in a table.
You delete all of them and then insert a small number of rows.

The second set of rows will get inserted at the start of the table, but a full table scan will still have to read all the blocks that previously had data in them.
Previous Topic: to kill a session
Next Topic: drop a synonym
Goto Forum:
  


Current Time: Sun Dec 04 04:15:16 CST 2016

Total time taken to generate the page: 0.06145 seconds