Author Topic: Oracle DBA Question 72  (Read 53 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 72
« on: April 24, 2009, 01:10:22 PM »
Question:
After running the ANALYZE INDEX orders cust_idx VALIDATE STRUCTURE command, you query the INDEX_STATS view and discover that there is a high ratio of DEL_LF_ROWS to LF_ROWS values for this index.
You decide to reorganize the index to free up the extra space, but the space should remain allocated to the ORDERS_CUST_IDX index so that it can be reused by new entries inserted into the index.
Which command(s) allows you to perform this task with the minimum impact to any users who run queries that need to access this index while the index is reorganized?

A. ALTER INDEX REBUILD
B. ALTER INDEX COALESCE
C. ALTER INDEX DEALLOCATE UNUSED
D. DROP INDEX followed by CREATE INDEX

Answer: B
To perform this task you need to use the ALTER INDEX COALESCE command to avoid overhead on the users who run queries that need access this index while the index is reorganized.

Techronnati | where technology never sleeps

Oracle DBA Question 72
« on: April 24, 2009, 01:10:22 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
62 Views
Last post April 19, 2009, 06:01:21 AM
by ralph0595
0 Replies
64 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
58 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
54 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.