Exam 1z0-083 topic 1 question 30 discussion

I think: CEF

C,E,F. The advisor task runs automatically in the maintenance window, but you can also run it on demand. https://docs.oracle.com/en/database/oracle/oracle-database/21/tgsql/optimizer-statistics-advisor.html#GUID-11B3764D-CCA1-415F-88DD-0F6884DF8D89

CEF correct

I think cef

From: https://docs.oracle.com/en/database/oracle/oracle-database/21/arpls/DBMS_STATS.html#GUID-A405E9B8-B8C8-400D-A838-F7DA161BE1A2 Optimizer Statistics Advisor inspects the statistics gathering process, automatically diagnoses problems in the existing practices for gathering statistics, and then generates a report of findings and recommendations. The advisor task runs automatically in the maintenance window. However, you can also run the job on demand.

agree with CEF

agree with CEF

Optimizer Statistics Advisor is built-in diagnostic software that analyzes the quality of statistics and statistics-related tasks. The advisor task runs automatically in the maintenance window, but you can also run it on demand. You can then view the advisor report. If the advisor makes recommendations, then in some cases you can run system-generated scripts to implement them. his section contains the following topics: Optimizer Statistics Advisor inspects how optimizer statistics are gathered. Optimizer Statistics Advisor uses the same advisor framework as Automatic Database Diagnostic Monitor (ADDM), SQL Performance Analyzer, and other advisors. Perform Optimizer Statistics Advisor tasks using the DBMS_STATS PL/SQL package. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/optimizer-statistics-advisor.html#GUID-D81A7708-FDA0-45BB-A6E2-103858B047AE

CEF - SOUNDS CORRECT

AUTO_STATS_ADVISOR_TASK The Optimizer Statistics Advisor runs a task called AUTO_STATS_ADVISOR_TASK during the maintenance window, so by default you don't need to do anything to start seeing advice about your database statistics.

DECLARE tname VARCHAR2(32767) := 'demo'; -- task name BEGIN tname := dbms_stats.create_advisor_task(tname); END; / DECLARE tname VARCHAR2(32767) := 'demo'; -- task name ename VARCHAR2(32767) := NULL; -- execute name BEGIN ename := dbms_stats.execute_advisor_task(tname); END; /

CEF, is the only right answer. A is not correct, daily maintenance window starts at 10pm and spans the whole night.

CEF The advisor task (‘Statistics Advisor‘) runs automatically in the maintenance window. And of course you can also run it on demand

Correct Answer: ACF https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/ https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf