|
|
原帖由 ffcsdch 于 2010-5-27 20:42 发表 ![]()
A:9207
B:10203
语句已经使用绑定变量！
我们是从OEM性能观察到大量的“1”语句的CPU消耗！session_cached_cursors =1000
Your observation that the first SQL uses lots of CPU is likely to be wrong. Check v$sql (or v$sqlstats or v$sqlarea) for cpu_time. The number is 0 for this SQL. There's no magic in OEM. It has to get the numbers from v$ views.
If you really want to optimize, focus on the second SQL, which does the real work and all stats are available.
Yong Huang |
|
楼主: ffcsdch
IP卡
狗仔卡
楼主
显身卡
发表于 2010-5-29 02:18