Oracle performance adjustment

xiaoxiao2021-03-06  82

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.

转载请注明原文地址:https://www.9cbs.com/read-124051.html

New Post(0)