Oracle Database Administration 2022 Certified Professional — Question 20

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? (Choose two.)

Answer options

• A. DBA_HIST_ACTIVE_SESS_HISTORY
• B. DBA_HIST_SQLSTAT
• C. DBA_HIST_SQLTEXT
• D. DBA_HIST_PGASTAT
• E. DBA_HIST_PROCESS_MEM_SUMMARY

Correct answer: A, E

Explanation

The correct views to identify the problematic process and query are DBA_HIST_ACTIVE_SESS_HISTORY, which provides historical session information, and DBA_HIST_PROCESS_MEM_SUMMARY, which gives insights into memory usage by processes. The other options either focus on SQL statistics or text, which are not directly related to identifying the process responsible for the PGA memory issue.