Multiple choice technology performance

This phase of Oracle tuning is directed at looking for resource shortages in the db_block_buffers, shared_pool_size and sort_area_size.

  1. Instance Tuning

  2. Object Tuning

  3. SQL Tuning

  4. Space Management
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Instance Tuning focuses on optimizing memory parameters like db_block_buffers (data cache), shared_pool_size (library cache), and sort_area_size (memory for sorting operations). These are instance-level resource configurations that affect the entire database instance, not individual objects or SQL statements.

AI explanation

Instance Tuning is correct. In the classic Oracle DBA tuning methodology, tuning is layered: Instance Tuning addresses memory/resource allocation at the instance (SGA/PGA) level — parameters like db_block_buffers, shared_pool_size, and sort_area_size directly control buffer cache size, shared pool memory, and sort work area, all instance-wide resources. Object Tuning concerns schema design (indexes, partitioning, storage clauses); SQL Tuning concerns individual query execution plans; Space Management concerns physical disk/tablespace allocation. Since the question specifically names instance-level memory parameters, Instance Tuning is the only fit.

Keep practicing — related questions