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.