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 following options:
· Restarting the Database
· Using Filters with Workload Capture
· Setting Up the Capture Directory
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 in RESTRICTED mode usingSTARTUP RESTRICT, which will only allow the SYS user to login and start the workload capture. By default, once the workload capture begins, any database instance that are in RESTRICTED mode will automatically switch to UNRESTRICTED mode, 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 be logically equivalent to that of the capture system at the start time of workload capture.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29555029/viewspace-1612582/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29555029/viewspace-1612582/