oracle any workload,oracle.1z0-053:workload capture and replay

QUESTION

NO: 39

Which two prerequisites are needed for performing workload capture and replay?

(Choose two.)

A. Close all sessions performing queries using database links.

B. running the database in shared server mode

C. The database on which the workload is replayed has to be a restore of the

original database to

a specific SCN.

D. setting up the directory to capture the workload

Answer: C,D

Explanation:

Before capturing a

database workload, carefully consider the followingoptions:

·

·

·

Once the database is restarted, it is important

to start the workload capture before any user sessions reconnect and start

issuing any workload. Otherwise, transactions performed by these user sessions

will not be replayed properly in subsequent database replays, because only the

part of the transaction whose calls were executed after the workload capture is

started will be replayed. To avoid this problem, consider

restarting the database inRESTRICTEDmode

usingSTARTUP RESTRICT, which will

only allow theSYSuser

to login and start the workload capture. By default, once the workload capture

begins, any database instance that are inRESTRICTEDmode

will automatically switch toUNRESTRICTEDmode, and normal operations can continue while the workload is being

captured.

Before a workload can be replayed, the

application data state of the replay system should belogically

equivalent to that of the capture system at the start time of workload capture.