Home » RDBMS Server » Server Administration » Table reorganize?
Table reorganize? [message #315921] Wed, 23 April 2008 04:28 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi,

I have EXAMP table in which contains 100.000.000 records.
I do delete 100.000 records everyday from the table. Also from the application there are insertion of other records paralally.
I do rebuild indexes within a month.

My question is does the table needs to be reorganized for the better performance?
If deletion/addition of records goes on continously then will it cause performance problem?

Thanks,

Report message to a moderator

Re: Table reorganize? [message #315929 is a reply to message #315921] Wed, 23 April 2008 04:54 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member
Hi

Reorganization substantially improves table performance.

go through this link

http://www.remote-dba.net/t_tuning_reorganizing_tables.htm

Regards
Gopu

Report message to a moderator

Re: Table reorganize? [message #315933 is a reply to message #315921] Wed, 23 April 2008 04:59 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Gopu,
I am agree with you that reorganization improves performance.

But in the current scenario as am i deleting records and addition of records from applcaition will it cause performance problem?

Report message to a moderator

Re: Table reorganize? [message #315938 is a reply to message #315929] Wed, 23 April 2008 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Reorganization substantially improves table performance.

This is wrong.
And J.Lewis already proved that Burleson article is full of myths.

Regards
Michel

[Updated on: Wed, 23 April 2008 05:14]

Report message to a moderator

Re: Table reorganize? [message #315953 is a reply to message #315938] Wed, 23 April 2008 06:00 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member
Michel Cadot wrote on Wed, 23 April 2008 05:14
Quote:
Reorganization substantially improves table performance.

This is wrong.
And J.Lewis already proved that Burleson article is full of myths.

Regards
Michel



K, sorry for that, i went through Mr.Burleson article.

Regards
Gopu

Report message to a moderator

Re: Table reorganize? [message #315957 is a reply to message #315921] Wed, 23 April 2008 06:12 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Whenvere we google for any information, the first site google shows
is dba-oracle.com.

Burleson claims to have years of experience and an oracle expert,then why he contradicts other oracle experts.
So he is not an oracle expert.
He is a newbie like me Laughing

Report message to a moderator

Re: Table reorganize? [message #315960 is a reply to message #315957] Wed, 23 April 2008 06:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
He is a newbie like me

But a "newbie" at 500$/hour... like you?

Regards
Michel

[Updated on: Wed, 23 April 2008 06:14]

Report message to a moderator

Re: Table reorganize? [message #315961 is a reply to message #315921] Wed, 23 April 2008 06:15 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
exactly, when he is so much wrong in the approach,why would anyone pay him for the myths?

Report message to a moderator

Re: Table reorganize? [message #315975 is a reply to message #315961] Wed, 23 April 2008 06:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
why would anyone pay him for the myths?

He find some and that kills me!
The principle is simple: if you dare to ask a lot of money then you surely a guru and so it worths to hire you.

Regards
Michel

Report message to a moderator

Re: Table reorganize? [message #315985 is a reply to message #315921] Wed, 23 April 2008 07:24 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
So he is a problem solver.
It is just that his approach is not appreciated by the rest of the world.

Report message to a moderator

Re: Table reorganize? [message #315988 is a reply to message #315985] Wed, 23 April 2008 07:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
It is just that his approach is not appreciated by the rest of the world.

What is not appreciate is that it shows in many forums and articles a bad behaviour without speaking about wrong informations.

Regards
Michel

Report message to a moderator

Re: Table reorganize? [message #316169 is a reply to message #315921] Thu, 24 April 2008 01:15 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
What is your database version?
If 10g use SEGMENT ADVISOR option will reorganize frgamented table.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schema.htm#sthref2102

Report message to a moderator

Previous Topic: Software install 11g on windows
Next Topic: upgrade oracle 10g DB from 10.2.0.3.0 to 10.2.0.4.0
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 01:08:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.