3.4 Administering Oracle Database Features on Exadata

Use these guidelines to use and administer the following Oracle Database features in conjunction with Oracle Exadata.

• Using Indexes on Exadata
  In the past, databases required indexes for good performance. However, Oracle Exadata can deliver superior scan rates without using indexes.
• Using SQL Tuning Advisor on Exadata
  SQL Tuning Advisor takes one or more SQL statements as input and uses the Automatic Tuning Optimizer to perform SQL tuning on the statements.
• Using SQL Plan Management on Exadata
  SQL plan management prevents performance regressions resulting from sudden changes to the execution plan of a SQL statement by recording and evaluating the execution plans of SQL statements over time.
• Using Exadata System Statistics
  System statistics measure the performance of CPU and storage so that the Oracle Database optimizer can use these inputs when evaluating SQL execution plans.
• Using the Same DB_UNIQUE_NAME for Multiple Database Instances
  You can create database instances that use the same DB_UNIQUE_NAME value if the databases are associated with separate Oracle ASM clusters.