So here's the next question you'll see. As we all know, Oracle will read up
to the high water mark on table scans. So, how do you lower the high water
mark without exp/imp?
1) alter table tab1 move...
- will this rebuild the table or just move all the allocated pages?
- I know it invalidates the indexes and they will need to be rebuilt so I
am assuming the table is rebuilt...
2) alter table tab1 deallocate unused?
- will this free up the allocated and unused pages and lower the HW mark?
anyone?
-----Original Message-----
From: Benny Pei [mailto:[Email Address Removed] Monday, July 30, 2001 5:23 PM
To: LazyDBA.com Discussion
Subject: Re: High Water Mark !!
Imagine your table is a big cup and you are filling in
grape juice or data. You pour in some and drink some.
After a while, your cup will have a "high water mark"
indicates where it has reached the highest.
i.e. HWM tells you how much data in tables went up the
highest.
Hope it makes sense. Ooops.. time to get some juice
myself too. :)
benny
--- Sean <[Email Address Removed] wrote:
>
> Hi All!
> what does High Water Mark means and indicate in
> terms of Rollback Segments
> Is this related to tablespaces,datafiles and tables
> also.
> Thanks
>
>
>
>
>
>
_______________________________________________________
> Send a cool gift with your E-Card
> http://www.bluemountain.com/giftcenter/
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page