Home » RDBMS Server » Server Administration » Table Fragmentation (Oracle 10g Rel2, Linux AS4)
Table Fragmentation [message #360455] Fri, 21 November 2008 01:28 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello ,

we have a task wherein we need to find out how what all the tables are fragmented and how to eliminate the fragmenation .

Elimination, I guess is done by taking export of the table and dropping the table and creating the table and importing the dump file into the newly created table .

please correct if I'm right and also help me in finding out the what all are the fragemented tables.

Regards,
Raj
Re: Table Fragmentation [message #360472 is a reply to message #360455] Fri, 21 November 2008 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
we have a task wherein we need to find out how what all the tables are fragmented and how to eliminate the fragmenation .

Define "fragmentation".
Explain why "fragmentation" is a problem and why you need to "defragment".

Regards
Michel
Re: Table Fragmentation [message #360535 is a reply to message #360455] Fri, 21 November 2008 05:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search the topic in this forum.
It is been beaten to death.
Ask yourself again and again the same question Michel has raised.
Re: Table Fragmentation [message #360730 is a reply to message #360455] Sun, 23 November 2008 12:43 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
This is amazing.
In an era of 11G and locally managed tablespaces,people still worry about table fragmentation.And these people with pathetic knowledge gets the job as a DBA.Who hired you and one that gave you the task???
Re: Table Fragmentation [message #360731 is a reply to message #360730] Sun, 23 November 2008 13:17 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
varu123 wrote:
>>And these people with pathetic knowledge gets the job as a DBA.Who hired you and one that gave you the task???

That was totally uncalled for.

Previous Topic: Memory Usage
Next Topic: Problem with Deleting Flashback Logs
Goto Forum:
  


Current Time: Wed Dec 07 02:41:15 CST 2016

Total time taken to generate the page: 0.60966 seconds