Top 500 + Oracle DRM Interview Questions and Answers - 1
What is parallel degree limit?
Parallel degree limit is an allocation method for degree of parallelism.
It specifies the maximum degree of parallelism for an operation.
It can be set using the PARALLEL_DEGREE_LIMIT_P1 parameter.
The default value of this parameter is null which indicates no limit is imposed.
What is a CPU method or parameter?
Oracles uses eight levels of CPU allocation namely, CPU_P1 to CPU_P8, to prioritize and allocate CPU usage among the competing user sessions.
What is an active session pool?
It specifies the maximum number of concurrently active sessions for a consumer group or sub plan. It can be set using the ACTIVE_SESS_POOL_P1 parameter.
The default value for this parameter is null which means unlimited.
What is an idle time?
Idle time is used to specify the number of seconds that a session can remain idle before the session is killed. It can be set using the MAX_IDLE_TIME parameter.
The default value of the parameter is null which indicates that no idle time limit is imposed.
Define resource consumer groups?
A resource consumer group is used to classify users into logical group based on their resource consumption requirements.
7000+ TNMAWS Questions and Answers Pdf More
Tamil Nadu Municipal Administration Water Supply Question Paper Pdf More
7000+ Nuclear Metals Questions and Answers Pdf More
7000+ Fuel System Questions and Answers Pdf More
7000+ Metallurgy Solved MCQS Questions Pdf More
100+ Antonyms Multiple Choice Questions with Answers Pdf More
Basic Computer Quiz Questions with Answers Pdf More
1000+ General Knowledge Questions with Answers for SSC Exams More
1000+ GRE Non Verbal Reasoning Questions and Answers Pdf More
1000+ Verbal Reasoning Questions for SSC Exams Pdf More