Home » RDBMS Server » Performance Tuning » Index Rebuld
Index Rebuld [message #65476] Thu, 30 September 2004 11:55 Go to next message
Diogenes
Messages: 8
Registered: September 2004
Junior Member
Hi Everybody





Im 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.

Re: Index Rebuld [message #65480 is a reply to message #65476] Fri, 01 October 2004 07:41 Go to previous messageGo to next message
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.
Re: Index Rebuld [message #65489 is a reply to message #65480] Wed, 06 October 2004 07:13 Go to previous messageGo to next message
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?
Re: Index Rebuld [message #65492 is a reply to message #65489] Wed, 06 October 2004 07:36 Go to previous message
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.
Previous Topic: URGET:-SQL statement not performing well.
Next Topic: Listener stabilish
Goto Forum:
  


Current Time: Sat Feb 24 17:27:54 CST 2024