최신 1z1-084 무료덤프 - Oracle Database 19c Performance and Tuning Management
Which two statements are true about session wait information contained in v$session or v$session_wait?
정답: A,C
설명: (DumpTOP 회원만 볼 수 있음)
Examine this command:
What is the maximum number of baselines generated by this command that you can have at any given time?
What is the maximum number of baselines generated by this command that you can have at any given time?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?
정답: A
설명: (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 회원만 볼 수 있음)
What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
Which two types of performance problems are reported by ADDM for PDBS?
정답: C,D
설명: (DumpTOP 회원만 볼 수 있음)