Top 500 + Oracle DRM Interview Questions and Answers - 1
Question: 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.
Question: 2
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.
Question: 3
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.
Question: 4
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.
Question: 5
Define resource consumer groups?
A resource consumer group is used to classify users into logical group based on their resource consumption requirements.
GATE Chemical Engineering Questions and Answers More
GATE 2024-2025 Question Paper Pdf Download More
Banking Awareness Questions 2024-2025 More
Computer Quiz Questions for Bank Exams More
Computer Quiz Questions for Bank Exams More
Active & Passive Voice Questions Answers for Class 6,7,8,9,10 More
100+ Direct/Simple Analogy Questions for Bank Exams Pdf More
Oracle DBA Structure Interview Questions and Answers Pdf More
1000+ English Grammar Questions and Answers for Competitive Exams More
1000+ Cloze Test Questions with Answers Pdf for SSC Exams More