Explain about the Optimizer values passed in Oracle?
- 1 Answers
- 3029 Views
- I also Faced
- E-Mail Answers
Answer Posted / Siddharth Kumar Srivastava
In Oracle, optimizer values are settings that control the optimization process for SQL statements. They include statistics-gathering parameters (such as STATISTICS_LEVEL and DB_BLOCK_BUFFERS), cost-based optimization parameters (such as OPTIMIZER_MODE and OPTIMIZER_INDEX_COST_ADJ), and parallel execution parameters (such as PARALLEL_MAX_SERVERS and PARALLEL_MIN_SERVERS). These values can be tuned to improve the performance of SQL statements.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
