フリー問題

Oracle Database 19c: Performance Management and Tuning のフリー問題 7 / 20 問目

問題文

A developer complains that a long report statement never appears in the real time monitoring pages while shorter statements from the same session do appear. Which condition brings a single statement under monitoring automatically?

選択肢

  1. The statement has raised a wait event of the concurrency class or it has been reoptimized after the first run.
  2. The statement has taken up five seconds or more of processor time or of input and output time within one execution or it runs in parallel.
  3. The statement has been captured into a tuning set or it has a plan stored in the repository for the period.
  4. The statement has been executed at least five times since the instance started or it belongs to a service that carries a name.

解答・解説を確認するには

正解と解説の確認、回答の記録には無料登録が必要です。登録すると演習モードでフリー問題に回答し、正誤と解説をその場で確認できます。