OraFAQ Forum: Server Administration » Rebuilding of Index (2 merged)

Home » RDBMS Server » Server Administration » Rebuilding of Index (2 merged) (Oracle 10.2.0.4 AIX 6L )

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

Rebuilding of Index (2 merged) [message #481097]

Sat, 30 October 2010 11:29

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello,

we have 25 GB free space in Index tablespace, to avoid space issue i have added 10GB of space. Next shift DBA, rebuild INDEX of the from INDEX tablespace. Now i can check, only 27GB free space in INDEX tablespace...

Rebuilding of INDEX takes extra space.. ???

Regards,
Jay vardhan.

Report message to a moderator

Re: Rebuilding of Index [message #481099 is a reply to message #481097]

Sat, 30 October 2010 11:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Rebuilding of INDEX takes extra space.. ???
Possibly yes & possibly no.
too few details available to speculate.

Report message to a moderator

Re: Rebuilding of Index [message #481100 is a reply to message #481099]

Sat, 30 October 2010 11:33

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Please let me know what details needed to check the issue

Report message to a moderator

Re: Rebuilding of Index [message #481101 is a reply to message #481100]

Sat, 30 October 2010 11:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what was index size before and after "rebuild"?
What was SQL issued?
Why was index rebuilt?

Report message to a moderator

Re: Rebuilding of Index (2 merged) [message #481102 is a reply to message #481097]

Sat, 30 October 2010 11:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same thing than in Index rebuild grows database size topic.
So same answers and same questions.
So please read the guide and post what is asked.

Regards
Michel

[Updated on: Sat, 30 October 2010 11:40]

Report message to a moderator

Re: Rebuilding of Index (2 merged) [message #481103 is a reply to message #481102]

Sat, 30 October 2010 12:23

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

what was index size before and after "rebuild"?
What was SQL issued?
Why was index rebuilt?

Answer is :

1) I don't have exact figure for Index size, what i monitor is tablespace free size.
2) select 'alter index '||owner||'.'||index_name || ' rebuild online;' from dba_indexes where tablespace_name='INDX';

Report message to a moderator

Re: Rebuilding of Index (2 merged) [message #481104 is a reply to message #481103]

Sat, 30 October 2010 12:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

what i monitor is tablespace free size

As you seem to not being able to read the other topic:
Copy and paste your session.
Copy and paste what you did and got.
And so on.
Please read it and paste ALL things that are asked.

Regards
Michel

Report message to a moderator

Re: Rebuilding of Index (2 merged) [message #481124 is a reply to message #481104]

Sun, 31 October 2010 10:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>select 'alter index '||owner||'.'||index_name || ' rebuild online;' from dba_indexes where tablespace_name='INDX';
It appears you blindly rebuild every INDEX; regardless of whether anything will change or not.
What a waste of resources!

Report message to a moderator

Previous Topic:	Index rebuild grows database size
Next Topic:	First time mover of database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 13:16:26 CST 2024