최신 1z1-084 무료덤프 - Oracle Database 19c Performance and Tuning Management
SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?
정답: A,G
설명: (DumpTOP 회원만 볼 수 있음)
Which three types of statistics are captured by statspack with snap level 6?
정답: B,C,D
설명: (DumpTOP 회원만 볼 수 있음)
This error occurred more than four hours ago in the database:
ORA-04036 PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
You want to know which process and query were at fault.
Which two views should you use for this purpose?
ORA-04036 PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
You want to know which process and query were at fault.
Which two views should you use for this purpose?
정답: D,E
설명: (DumpTOP 회원만 볼 수 있음)
You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:
Where do you find the output of this command?
Where do you find the output of this command?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?
정답: B,C,D
설명: (DumpTOP 회원만 볼 수 있음)
Examine this AWR report excerpt:
You must reduce the impact of database I/O, without increasing buffer cache size and without modifying the SQL statements.
Which compression option satisfies this requirement?
You must reduce the impact of database I/O, without increasing buffer cache size and without modifying the SQL statements.
Which compression option satisfies this requirement?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)