When you plan to adjust resource limits in any Oracle 10g database,you must first change the initialization parameter named ____.
A) RESOURCE_LIMITS
B) CPU_PER_CALL
C) PROFILE_LIMIT
D) COMPOSITE_LIMIT

Question

Quizplus · Accepted Answer

The correct initialization parameter to adjust resource limits in Oracle 10g database is RESOURCE_LIMITS. This parameter enables or disables resource limits for all sessions connected to the database. It can be set to TRUE or FALSE, depending on your requirement. Once enabled, you can configure specific resource limits for individual users using the CREATE PROFILE and ALTER USER commands. The other options listed (CPU_PER_CALL, PROFILE_LIMIT, and COMPOSITE_LIMIT) are not relevant for this purpose.

When You Plan to Adjust Resource Limits in Any Oracle