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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31544987/viewspace-2652147/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31544987/viewspace-2652147/