OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database reorg

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database reorg [message #222556]

Mon, 05 March 2007 07:10

sibusiso
Messages: 2
Registered: February 2007
Location: South Africa

Junior Member

Hi Guys, wnats the best way to reorg a database, how would
i find out which segements would befenit from a reorg??

Report message to a moderator

Re: Database reorg [message #222559 is a reply to message #222556]

Mon, 05 March 2007 07:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
basically you can use EXPORT/IMPORT utility.
or
alter table tablename move tablespace tablespacename + rebuild all indexes.

Many Factor depand on Database Size.
http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1046468_tax296619,00.html

you should read above article ...

regards
Taj

Report message to a moderator

Re: Database reorg [message #222563 is a reply to message #222559]

Mon, 05 March 2007 07:31

sibusiso
Messages: 2
Registered: February 2007
Location: South Africa

Junior Member

Thanks Mohammed but now how do i see if the table or tablespace
needs to be reorged, would a table with chained rows be a good canditate for a reorg??

Report message to a moderator

Re: Database reorg [message #222603 is a reply to message #222563]

Mon, 05 March 2007 10:50

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> would a table with chained rows be a good canditate for a reorg
Not exactly.
Then you may need to do it too frequenly all your lifetime.
Question is why would you like to do a re-org?
If it is for the so said fragmentation, it is a dead concept.
In 9i and above use LMT with uniform extent size. you can avaoid almost any fragment (still interblock framentation would be present. Using proper pctfree/pctused is the only option).
I would rather check for HWM.
Ross talks about a simple method here
http://www.orafaq.com/forum/m/215453/42800/?srch=FIND+HWM#msg_215453
And arguments are supported here
http://orafaq.com/faq/where_can_one_find_the_high_water_mark_for_a_table
A longer version (in a different view and examples) is available here
http://www.orafaq.com/forum/m/207412/42800/?srch=reorg+tablespace#msg_150807

Please search this forum for more results.

[Updated on: Mon, 05 March 2007 10:51]

Report message to a moderator

Previous Topic:	MMON: "KEWRAFC: Flush slave failed, return Code: 5."
Next Topic:	Shared Server Configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:24:43 CDT 2024