|
p; 0 0 0 000000007C4BE340 000000007BD3F308 4528 8088 6080 18696 18696 1692266099 a31kd5tkdvvmm 1
子游标句柄地址 000000007CD3B6D0 000000007CD3E1C0 SELECT DEPTNO FROM DEPT WHERE DEPTNO=10 0 0 0 000000007CBF7AC8 000000007C08D4E8 4544 8088 6080 18712 18712 1692266099 a31kd5tkdvvmm 2
父游标句柄地址 000000007CD3E1C0 000000007CD3E1C0 SELECT DEPTNO FROM DEPT WHERE DEPTNO=10 0 0 0 000000007CA31368 00 8792 0 0 8792 8792 1692266099 a31kd5tkdvvmm 65535
--//KGLOBHD0=000000007CA31368.
--//也就是metux的结构体在父游标的堆0中,为什么放在父游标的堆0中,而不是各个子游标的堆0中.
--//集中管理吗?不知道....
SCOTT@book> select method,count(*),round(avg(TIME_ELA),0),sum(TIME_ELA) from job_times group by method order by to_number(substr(method,4)),3;
METHOD COUNT(*) ROUND(AVG(TIME_ELA),0) SUM(TIME_ELA)
-------------------- ---------- ---------------------- -------------
g2_150 150 19804 2970658
f2_150 150 19871 2980723
d2_150 150 20575 3086315
--//这样因为参数不同,争用相对减少,反而快一点点.
4.如果脚本修改如下:
$ cat m2.txt
set verify off
column a noprint new_val |