Oracle
1Z0-064 · Question #84
You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them. Which two tasks would you perform to test the…
The correct answer is A. Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the C. Set the PUBLISH statistics preference to FALSE and then gather statistics. See the full explanation below for the reasoning.
Question
You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them. Which two tasks would you perform to test the new statistics? (Choose two.)
Options
- ASet the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the
- BSet the STALE_PERCENT statistics preference to zero and then gather statistics.
- CSet the PUBLISH statistics preference to FALSE and then gather statistics.
- DUse the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the
- ESet the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting
How the community answered
(61 responses)- A80% (49)
- B3% (2)
- D5% (3)
- E11% (7)
Community Discussion
No community discussion yet for this question.