Which two tasks would you perform to test the new stati…

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.)

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.)

A.
Set theOPTIMIZER_USE_PENDING_STATISTICSinitialization parameter toTRUEfor
the session.

B.
Set theSTALE_PERCENTstatistics preference to zero and then gather statistics.

C.
Set thePUBLISHstatistics preference toFALSEand then gather statistics.

D.
Use theDBMS_STATS.PUBLISH_PENDING_STATSprocedure to make pending
statistics the current statistics.

E.
Set theNO_INVALIDATEstatistics preference toFALSEand gather statistics without
affecting old statistics.



Leave a Reply 4

Your email address will not be published. Required fields are marked *