053第42题
42.You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning
Set as a part of the workload capturing. What information is captured as part of this process?
(Choose all
that apply.)
A. the SQL text
B. the execution plan
C. the execution context
D. the execution frequency
E. the system change number (SCN)
Answer: ACD
Before running SQL Performance Analyzer, capture a set of SQL statements on the production system that represents the SQL workload which you intend to analyze.
The captured SQL statements should include the following information:
-
SQL text
-
Execution environment
-
SQL binds, which are bind values needed to execute a SQL statement and generate accurate execution statistics
-
Parsing schema under which a SQL statement can be compiled
-
Compilation environment, including initialization parameters under which a SQL statement is executed
-
-
Number of times a SQL statement was executed
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步