nerdexam
Oracle

1Z0-054 · Question #185

You are managing an online transaction processing (OLTP) system. The database is supporting a large number of applications using connection pools to connect to the database. Which method would you…

The correct answer is A. Service aggregation for action within application module. See the full explanation below for the reasoning.

Question

You are managing an online transaction processing (OLTP) system. The database is supporting a large number of applications using connection pools to connect to the database. Which method would you use for performance management?

Options

  • AService aggregation for action within application module
  • BMonitoring individual sessions by querying V$SESSION_LONGOPS
  • CMonitoring individual sessions in an application by querying V$SESSION
  • DMapping the sessions for an application to one resource consumer group

How the community answered

(26 responses)
  • A
    81% (21)
  • B
    4% (1)
  • C
    12% (3)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice