Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 387 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
does existing user and new connection affect when we rebuild a index ?

vishal patel
Member Posts: 368
Hi
All,
I have oracle 10.2.0.3 on AIX 5.2
does existing user and new connection affect when we rebuild a index?
Thanks,
Vishal
All,
I have oracle 10.2.0.3 on AIX 5.2
does existing user and new connection affect when we rebuild a index?
Thanks,
Vishal
Tagged:
Answers
-
does existing user and new connection affect when we rebuild a index?
What kind of efect you are mentioning?
Aman.... -
Hii..
let me try to answer your query, it might not be 100% correct.
When you rebuild the index using ONLINE clause then, the copy of the index is maintained which is modified and then replaces the old index and by the time the new one is rebuilt the older one is used by the users.Whereas, when you simply do , alter index indexname rebuild; the index goes into unusable state and will not be available to the users.If the index which is going to be rebuilt is already being used by someone then you will get ORA error sayin RESOURCE BUSY WAIT...
Anand -
1. A REBUILD locks the table (the table can still be queried). A REBUILD ONLINE allows operations to run concurrently against the table.
2. You run the risk of ORA-01410 errors. For a good explanation see http://jonathanlewis.wordpress.com/2007/09/16/index-rebuild/
3. In 10g and above a REBUILD implicitly updates statistics on the Index. This can change execution plans as Oracle parses SQL statements that execute after the REBUILD.
But, generically, existing user connections and user queries are NOT affected by a rebuild.
Hemant K Chitale
http://hemantoracledba.blogspot.com
This discussion has been closed.