You are working on an online transaction processing (OLTP) system. The middle-tier applications use connection pooling t

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You are working on an online transaction processing (OLTP) system. The middle-tier applications use connection pooling t

Post by answerhappygod »

You are working on an online transaction processing (OLTP) system. The middle-tier applications use connection pooling to connect to the database. Presently, you have a single-node database. The company plans to migrate the database to a RAC environment.Before you move to a RAC environment, you want to test the performance of the SQL statements and the peak workload on the new environment. To accomplish the DatabaseCapture for replay, you identified the peak workload period on the existing system and started the Database Capture. Which client requests to the database can be captured as part of the workload capture? (Choose all that apply.)

A. flashback query
B. distributed transactions
C. logging in and logging out of sessions
D. all DDL statements having bind variables E. direct path load of data from external files
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply