1Z0-084 무료 덤프문제 온라인 액세스

Buffer cache access is too frequent when querying the SALES table. Examine this command which executes successfully:
ALTER TABLE SALES SHRINK SPACE;
For which access method does query performance on sales improve?

• A.index range scan
• B.db file scattered read
• C.db file sequential read
• D.index full scan

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.reducing the values of DB_FILE_MULTILOCK_READ_COUNT to 64
• B.setting dbwr_io_slaves to 64
• C.increasing the value of DBWRITERPROCESSES to 64,
• D.increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT to 128
• E.Increasing the size of MEMORYTARGET

Examine this statement and output:

Which two situations can trigger this error?

• A.There is a file in the capture directory.
• B.The syntax is incomplete.
• C.The capture directory is part of the root file system.
• D.The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory.
• E.The instance is unable to access the capture directory.

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.Use DBMS_AUTO_TASK_ADMIN. DISABLE to disable the AUTO_STATS_ADVISOR_TASK task.
• D.Set the AUTO_STATS_ADVISOR_TASK global statistics preference to FALSE.

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?

• A.Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.
• B.When WAIT TIME is high, instance tuning may improve performance.
• C.Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.
• D.Parse Time Elapsed accounts for successful soft and hard parse operations only.
• E.DB Time accounts for all time used by background processes and user sessions.
• F.The proportion of WAIT TIME to CPU TIME always increases with increased system load.