Home » RDBMS Server » Server Administration » Database reorg
Database reorg [message #222556] Mon, 05 March 2007 07:10 Go to next message
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??
Re: Database reorg [message #222559 is a reply to message #222556] Mon, 05 March 2007 07:24 Go to previous messageGo to next message
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
Re: Database reorg [message #222563 is a reply to message #222559] Mon, 05 March 2007 07:31 Go to previous messageGo to next message
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??
Re: Database reorg [message #222603 is a reply to message #222563] Mon, 05 March 2007 10:50 Go to previous message
Mahesh Rajendran
Messages: 10672
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:
  


Current Time: Sat Dec 03 17:51:56 CST 2016

Total time taken to generate the page: 0.05491 seconds