OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Index Rebuld

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

Index Rebuld [message #65476]

Thu, 30 September 2004 11:55

Diogenes
Messages: 8
Registered: September 2004

Junior Member

Hi Everybody

�

I�m so hurry to get a fast solution for rebuild the database index without using space, I mean using the same space available I have on my disk.

�

The situation is that I had loaded a full export coming from an external server and for optimizing the database performance I need to rebuild the indexes, I was using the script called �idxrebld.sql that is posted at the site but it ask me for more space.

�

What do you suggests Gurus?

�

�

Eager to read your recomenadatios

�

Diogenes Suero.

Report message to a moderator

Re: Index Rebuld [message #65480 is a reply to message #65476]

Fri, 01 October 2004 07:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Rebuilding the index has nothing to do with the performance.

but it sure is
- painful
- will not help anything
- your spacerequirements increase
- Generate a whole lot of redo-records.

If you have choosen the REBUILD ONLINE option,
MORE TEMP SPACE IS needed. why?

When you rebuild index online,
- it will do a full tablescan on the base table.
- At the same time it will maintain a journal table for DML data, which has
changed during this index rebuilding operation.
So it should take longer time, specially if you do lots of DML on the same table,
while rebuilding index online.
And It needs MORE SPACE to maintain the old and new index values.

TRY To rebuild without using ONLINE options
Oracle will grab
the index in X-mode and rebuild a new index segment by selecting the data from
the old index.
You may not encounter those space issues. BUt IT is NOT GOING TO HELP ANYTHING IN PERFORMANCE.

Report message to a moderator

Re: Index Rebuld [message #65489 is a reply to message #65480]

Wed, 06 October 2004 07:13

Diogenes
Messages: 8
Registered: September 2004

Junior Member

Hey thanks a lot for you help.

Now, I am having another problem.

I had configured the listener for my database and a service name for the database, but every time a restart the machine server, the clients even locally don't get to connect to my database.

I have proved the network connections but everything is fine.

What do you think is happening?

Report message to a moderator

Re: Index Rebuld [message #65492 is a reply to message #65489]

Wed, 06 October 2004 07:36

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

after the reboot the listener may not be started.
You can configure to autostart the database and listener after a reboot.
If using windows have a look here

http://www.orafaq.com/faqwinnt.htm#autostart

in case of unix,
dbstart/dbshut scripts in $ORACLE_HOME/bin will do the job.
add those script to your init.d
similarly lsncrtl start LISTENER_NAME will start the listener.

Report message to a moderator

Previous Topic:	URGET:-SQL statement not performing well.
Next Topic:	Listener stabilish

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 04:02:29 CDT 2024