Oracle
1Z0-117 · Question #116
You are administering a database that supports an OLTP application. To set statistics preferences, you issued the following command: SQL > DBMS_STATS.SET_GLOBAL_PREFS (ESTIMATE_PERCENT', 9'); What…
The correct answer is C. The automatic statistics gathering job running in the maintenance window will use global preferences even. With the DBMS_STATS package you can view and modify optimizer statistics gathered for database objects. The SET_GLOBAL_PREFS procedure e is used to set the global statistics preferences. * ESTIMATE_PERCENT - The value determines the percentage of rows to estimate. The valid…
Gathering Optimizer Statistics
Question
You are administering a database that supports an OLTP application. To set statistics preferences, you issued the following command:
SQL > DBMS_STATS.SET_GLOBAL_PREFS (ESTIMATE_PERCENT', 9'); What will be the effect of executing this procedure?
Options
- AIt will influence the gathering of statistics for a table based on the value specified for ESTIMATE_PERCENT
- BIt will influence dynamic sampling for a query to estimate the statistics based on ESTIMATE_PERCENT.
- CThe automatic statistics gathering job running in the maintenance window will use global preferences even
- DNew objects created will use global preference even if table preferences are specified.
How the community answered
(45 responses)- A2% (1)
- B4% (2)
- C84% (38)
- D9% (4)
Explanation
- With the DBMS_STATS package you can view and modify optimizer statistics gathered for database objects. * The SET_GLOBAL_PREFS procedure e is used to set the global statistics preferences. * ESTIMATE_PERCENT - The value determines the percentage of rows to estimate. The valid range is [0.000001,100]. Use the constant DBMS_STATS.AUTO_SAMPLE_SIZE to have Oracle determine the appropriate sample size for good statistics. This is the default.
Topics
#DBMS_STATS#global preferences#ESTIMATE_PERCENT#automatic statistics
Community Discussion
No community discussion yet for this question.