Which statement is true about limiting PGA usage for those users’ sessions?

You want to restrict PGA usage to 200 MB for a set of database users’ sessions as part of your organization’s security requirements for combating denial of service (DOS) attacks.
Which statement is true about limiting PGA usage for those users’ sessions?
A. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.
B. You cannot limit PGA for a set of database user sessions.
C. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.
D. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.
E. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.