Big Cyber Monday Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

  1. Home
  2. Discussions
  3. Oracle
  4. Oracle Database 19c
  5. 1z0-084 Discussions
  6. 1z0-084 Exam Topic 1 Question 9 Discussion

Oracle Database 19c: Performance Management and Tuning 1z0-084 Question # 9 Topic 1 Discussion

 Oracle Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Oracle Database 19c: Performance Management and Tuning 1z0-084 Question # 9 Topic 1 Discussion

1z0-084 Exam Topic 1 Question 9 Discussion:
Question #: 9
Topic #: 1

18. The application provider has given full indications regarding the procedure to collect statistics.

To reduce the space used in the SYSAUX tablespace, you want to prevent the optimizer statistics Advisor from running.

Which method will allow you to do this?
A.

Set the parameter OPTIMIZER_ADAPTIVE_STATISTICS to FALSE.

B.

Use DBMS_AUTO_TASK_ADMIN. DISABLE to disable the AUTO_STATS_ADVISOR_TASK task.

C.

Set the AUTO_STATS_ADVISOR_TASK global statistics preference to FALSE.

D.

Use DBMS STATS.DROP ADVISOR TASK to drop the AUTO_STATS_ADVISOR_TASK task.

Get Premium 1z0-084 Questions
Actual exam question for Oracle 1z0-084 exam by Ember88148 at Nov 12, 2025, 12:20:04 PM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next