問題文
An administrator reviews how the workload history of a database is collected for later analysis. Which statement about the automatic workload repository is correct?
選択肢
- It takes periodic snapshots of the cumulative statistics and keeps them for a configured period so later reports can compare two points in time.
- It writes the execution plan of each new cursor into a table and keeps the plans until the next restart so later reports can show plan changes.
- It records every statement executed by every session and keeps the text for a configured period so later reports can replay the same workload.
- It samples the active sessions every second and keeps the samples only in memory so later reports have to be produced while the instance stays up.