Re: Defrag/Reorg Tool

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Thu, 12 Feb 2009 14:29:13 -0800 (PST)
Message-ID: <706529.37543.qm_at_web52806.mail.re2.yahoo.com>

I should clarify the need for this tool.

At some point we over-allocated the tablespaces. So, we have large datafiles, but with lot of space not being used (holes) currently. We want to reclaim this space, such as by shrinking (resize) the datafiles. But, since there are one or blocks at the end of the datafile in a lot of cases, the shrink doesn't work very well. If instead there is a tool that can move the blocks that are at the end of the datafile(s) to somewhere in the beginning of the free space, the resize could work.

HTH,
Deepak

---

From: Dan Norris <dannorris_at_dannorris.com> To: "sharmakdeep_oracle_at_yahoo.com" <sharmakdeep_oracle_at_yahoo.com> Cc: Oracle L <oracle-l_at_freelists.org> Sent: Thursday, February 12, 2009 4:13:17 PM Subject: Re: Defrag/Reorg Tool

I suggest you review a presentation by Tom Kyte on reorganizing objects that he gave yesterday at RMOUG. I expect it should be on his website somewhere.

Short version: you probably don't need to do anything.

Dan

Sent from my iPhone

On Feb 12, 2009, at 3:00 PM, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:

I wanted to get recommendations on tools for online reorg/defrag of multi-terrabyte Oracle database.

Thanks in advance for your feedback.

-Deepak
      

--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 12 2009 - 16:29:13 CST