Home » RDBMS Server » Performance Tuning » Oracle 8 rebuild index
Oracle 8 rebuild index [message #167060] Tue, 11 April 2006 02:35 Go to next message
marco118
Messages: 16
Registered: March 2006
Junior Member
Hi All

May I know when I rebuild index in Oracle8, what is database status should be? eg, startup mount or startup open mode?

In additional, there are totally 3125 indexes in DB, any fast method or PL/SQL can chase out which index are need to rebuild?
(Manually rebuild index for 3125 is a nightmare)! Thanks!
Best Regards
Marco
Re: Oracle 8 rebuild index [message #167083 is a reply to message #167060] Tue, 11 April 2006 04:50 Go to previous messageGo to next message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
you can not access indexes in any state other than open, why do you want rebuild indexes just curious

Thanks
Madhu

[Updated on: Tue, 11 April 2006 04:51]

Report message to a moderator

Re: Oracle 8 rebuild index [message #167101 is a reply to message #167060] Tue, 11 April 2006 06:06 Go to previous messageGo to next message
marco118
Messages: 16
Registered: March 2006
Junior Member
Hi

It is because User feel slowly query on their Application, I haven't shutdown the database for nearly 8 months base on a lot of user is connecting to database even at night! I want rebuild index , but the disk usage is reach to 90%. abit worry in my case if I rebuld index online.

Marco
Re: Oracle 8 rebuild index [message #167110 is a reply to message #167101] Tue, 11 April 2006 07:00 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Recently, it happens to be a small discussion on rebuilding. Following is the link, hope you will get good information there.

http://www.orafaq.com/forum/m/164822/72347/#msg_164822
Re: Oracle 8 rebuild index [message #167114 is a reply to message #167060] Tue, 11 April 2006 07:28 Go to previous message
marco118
Messages: 16
Registered: March 2006
Junior Member
Thanks tarundua ! I will check it!@
Previous Topic: Monitoring memory used by oracle process
Next Topic: Temporary segment when fetching.
Goto Forum:
  


Current Time: Sun May 26 22:39:58 CDT 2024