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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 10708
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.

Report message to a moderator

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???

Report message to a moderator

Re: Table Fragmentation [message #360731 is a reply to message #360730] Sun, 23 November 2008 13:17 Go to previous message
Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 18:46:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.