Oracle Performance Adjustment is generally through Statspack, generating an analysis tracking file to locate the SQL statement with low efficiency. Then pass a variety of means, such as the appropriate index, add a suitable Hint to adjust the query statement; use alter index
Monitoring Usage; Tracking the index that is not used and deletes these indexes, adjusts the index of the efficiency (especially the index on the big table), plus / * append * / prompt, bulk insertion, etc. to adjust the DML statement.