在清单6中,从根据计数器作为初始步骤的动态sql快照数据中,您可以从总体成本、频率和每次调用成本角度列出最优sql语句。
From dynamic SQL snapshot data as the initial step based on the counters in Listing 6, you should be able to list out the top SQL statements in terms of total cost, frequency, and cost per invocation.
在计数器的示例中,冒险的步骤是递增——它检索旧值并在旧值上加一,希望在计算更新期间值不会变化。
In the case of the counter, the speculative step is the increment — it fetches and adds one to the old value in the hopes that the value will not change while the update is being computed.
步骤7:从Stats对象获取各种PM i计数器。
应用推荐