OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Table reorganize?

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

Table reorganize? [message #315921]

Wed, 23 April 2008 04:28

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

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

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

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

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

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

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

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:49:52 CDT 2024