请问下下面的6个ordered by中的参数是什么意思啊,如
SQL ordered by Gets for DB中的:
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash ValueSQL ordered by Reads for DB中的
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
(1)
SQL ordered by Gets for DB: CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
574,385,455 1,516,095 378.9 63.7 697.87 666.88 1216078387
Module: hbdxsms@zfw4 (TNS V1-V3)
Select Msglevel, Count(*) From Tf_Msgsend where 1=1 and ((attime
is null) or (attime<=to_char(sysdate,'yyyymmddhh24mmss'))) and
msglevel>=9 Group By Msglevel Order By Msglevel(2)
SQL ordered by Reads for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
74,147,632 12,086 6,135.0 67.4 897.46 911.04 745392646
update tf_msgrecv set STATUS = :1 where pk =:2(3)
SQL ordered by Executions for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
select TO_CHAR(sysdate,'YYYYMMDDHH24MISS') from dual(4)
SQL ordered by Parse Calls for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Parse Calls Threshold: 1000 % Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
1,516,095 1,516,095 40.26 1216078387
Module: hbdxsms@zfw4 (TNS V1-V3)
Select Msglevel, Count(*) From Tf_Msgsend where 1=1 and ((attime
is null) or (attime<=to_char(sysdate,'yyyymmddhh24mmss'))) and
msglevel>=9 Group By Msglevel Order By Msglevel(5)
SQL ordered by Parse Calls for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
:msgformat,
:recvtime,
:srctermid, :destt 12,086 12,086 0.32 745392646
update tf_msgrecv set STATUS = :1 where pk =:2
(6)
SQL ordered by Version Count for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Version Count Threshold: 20 Version
Count Executions Hash Value
-------- ------------ ------------
34 105,719 88041726
insert into TF_MSGSEND(pk,needreply,msglevel,serviceid,m
sgformat,feetype,feecode,fixedfee,validtime,attime,chargetermid,
desttermid,replypath,msglen,msgcontent,msgid,errorcode,msgtype,s
tatus,status_date,userid,region_id,sourcechannel,srctermid)
values(SEQ_SEND_ID.NEXTVAL,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1
SQL ordered by Gets for DB中的:
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash ValueSQL ordered by Reads for DB中的
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
(1)
SQL ordered by Gets for DB: CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
574,385,455 1,516,095 378.9 63.7 697.87 666.88 1216078387
Module: hbdxsms@zfw4 (TNS V1-V3)
Select Msglevel, Count(*) From Tf_Msgsend where 1=1 and ((attime
is null) or (attime<=to_char(sysdate,'yyyymmddhh24mmss'))) and
msglevel>=9 Group By Msglevel Order By Msglevel(2)
SQL ordered by Reads for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
74,147,632 12,086 6,135.0 67.4 897.46 911.04 745392646
update tf_msgrecv set STATUS = :1 where pk =:2(3)
SQL ordered by Executions for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
select TO_CHAR(sysdate,'YYYYMMDDHH24MISS') from dual(4)
SQL ordered by Parse Calls for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Parse Calls Threshold: 1000 % Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
1,516,095 1,516,095 40.26 1216078387
Module: hbdxsms@zfw4 (TNS V1-V3)
Select Msglevel, Count(*) From Tf_Msgsend where 1=1 and ((attime
is null) or (attime<=to_char(sysdate,'yyyymmddhh24mmss'))) and
msglevel>=9 Group By Msglevel Order By Msglevel(5)
SQL ordered by Parse Calls for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
:msgformat,
:recvtime,
:srctermid, :destt 12,086 12,086 0.32 745392646
update tf_msgrecv set STATUS = :1 where pk =:2
(6)
SQL ordered by Version Count for DB: ORCL Instance: orcl Snaps: 1 -2
-> End Version Count Threshold: 20 Version
Count Executions Hash Value
-------- ------------ ------------
34 105,719 88041726
insert into TF_MSGSEND(pk,needreply,msglevel,serviceid,m
sgformat,feetype,feecode,fixedfee,validtime,attime,chargetermid,
desttermid,replypath,msglen,msgcontent,msgid,errorcode,msgtype,s
tatus,status_date,userid,region_id,sourcechannel,srctermid)
values(SEQ_SEND_ID.NEXTVAL,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1
解决方案 »
- 请问查询该表是不是分区表的语句除了以下还有其他写法么?
- 请问这个程序有错吗,关于外键的
- oracle 客户端安装报path错误
- oracle where and or问题
- 编译Oracle自带的occi例子,可以通过,但是一运行就core dump
- 其他电脑连Oracle,提示无监听程序,重启Oracle服务器就好了,过段时间又提示无监听程序
- job中能不能写truncate table?我写的怎么总是报错?
- exp/imp完全恢复数据库的问题
- 在存储过程中什么返回错误信息给客户端呢?
- 在Oracle8.17中如何修改internal上的口令?
- !!!!! 求 oracle11g RAC相关知识的中文资料^^^^^^^^^
- 我用Intelligent converters 连接Oracle数据库时一直报错
正确,用指定的统计量来你的sql进行排序