Which two are true about Optimizer Statistics?
A)They are gathered by the Manageability Monitor(MMON) background process.
B)They can be gathered by executing the PL/SQL procedures in the DBMS_STATES package.
C)They do not persist across instance restarts.
D)They can be used to determine the events on which a database instance waited.
E)They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements.
F)They are automatically updated when DDL statements execute.
Answer: BE
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。