1Z0-084 practice question 4 of 15
Which procedure gathers statistics that are always used in the generation of any execution plan?
Full set: 55 questionsSystem statistics, gathered by DBMSSTATS.GATHERSYSTEMSTATS, describe the database server's hardware characteristics, such as I/O and CPU performance. The cost-based optimizer uses these statistics to model the cost of every operation (e.g., a full table scan vs. an index scan) when generating any execution plan. Unlike object statistics, which are specific to the tables and indexes in a query, system statistics provide the fundamental cost model for all optimizer decisions.
A. Dictionary statistics are only used for queries against data dictionary objects, not for any execution plan.
B. Fixed object statistics are only used for queries against fixed objects (X$ tables, V$ views), not for any execution plan.
C. Database (object) statistics are used for queries involving those specific objects, but the underlying cost model for operations relies on system statistics.
1. Oracle Database SQL Tuning Guide, 19c, "Optimizer Statistics Concepts", Section 4.2.4 "System Statistics". It states, "System statistics enable the query optimizer to more accurately estimate I/O and CPU costs."
2. Oracle Database PL/SQL Packages and Types Reference, 19c, "DBMSSTATS", "GATHERSYSTEMSTATS Procedure". The documentation describes this procedure as the method for gathering system statistics for the cost-based optimizer.
Keep practicing
Take the free 1Z0-084 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-084 practice questions
- Question 1What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS…
- Question 2You execute the following: EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE; Which advisor remains en…
- Question 3You must produce a consolidated formatted trace file by combining all trace files generat…
- Question 5Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and…
- Question 6Which two Oracle Database features use database services?
- Question 7Which two statements are true about cursor sharing?
