問題文
A database has been running for a week and the administrator wants an automatic assessment of the biggest performance problems. What does the automatic database diagnostic monitor deliver?
選択肢
- It analyzes each pair of snapshots and names the findings ordered by the time they cost and it also names the parts that need no attention.
- It analyzes the storage layout and moves the hottest segments to faster devices and it also reports the movements it performed during the window.
- It analyzes each statement in the shared pool and rewrites the ones with a poor plan and it also records the rewrites for a later review.
- It analyzes the session samples of the last minute and shows the current blockers and it also refreshes that view every few seconds for the operator.