1Z0-084試験無料問題集（57題）「Oracle Database 19c Performance and Tuning Management 認定」

出題：1

A database supporting a mixed workload is hosted on a server with 64 CPUs.
A large number of free buffer waits and buffer busy waits occur affecting performance.
The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.
Examine these parameter settings:

Which two actions can help reduce the number of these waits7

A. setting dbwr_io_slaves to 64

B. increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT to 128

C. reducing the values of DB_FILE_MULTILOCK_READ_COUNT to 64

D. Increasing the size of MEMORYTARGET

E. increasing the value of DBWRITERPROCESSES to 64,

正解：A,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?

A. Statistics Collector

B. Dynamic Statistics

C. Statistics Feedback

D. Automatic Reoptimization

E. SQL Plan Directives

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

The CURS0R_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an awr report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses?

A. Set the CURSOR_SHARING parameter to FORCE.

B. Create the KEEP cache and cache tables accessed by the SQL statements.

C. Create the RECYCLE cache and cache tables accessed by the SQL statements.

D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.

E. Increase the size of the library cache.

正解：A,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?

A. V$RMAN_BACKUP_JOB_DETAILS

B. V$SESSION_LONGOPS

C. V$SESSION

D. V$SESSTAT

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

A. With a target of 700 MB or more, all multipass executions work areas would be eliminated.

B. GGREGATE_TARGET should be set to at least 700 MB.

C. With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

D. PGAA_AGGREGATE should be set to at least 800 MB.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

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. Use DBMS STATS.DROP ADVISOR TASK to drop the AUTO_STATS_ADVISOR_TASK task.

B. Set the parameter OPTIMIZER_ADAPTIVE_STATISTICS to FALSE.

C. Set the AUTO_STATS_ADVISOR_TASK global statistics preference to FALSE.

D. Use DBMS_AUTO_TASK_ADMIN. DISABLE to disable the AUTO_STATS_ADVISOR_TASK task.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1Z0-084試験無料問題集「Oracle Database 19c Performance and Tuning Management 認定」