ITPub博客

首页 > 数据库 > Oracle > TimingStatisticsInDifferentSqlplusVersion

TimingStatisticsInDifferentSqlplusVersion

原创 Oracle 作者:YoungEric 时间:2009-06-15 09:39:33 0 删除 编辑

TimingStatisticsInDifferentSqlplusVersion

--Eric, Jun 13, 2009

This chapter introduces the different display mode of timing statistics between SQL*PLUS 8.0 and SQL*PLUS 10.2.

In the fixed SQL*PLUS version , the display mode can’t be modified.

SQL*PLUS8.0

In SQL*PLUS 8.0, if you execute the command “set timing on”, when we execute a SQL command , the display of timing statistics’s mode is millisecond, not our normal time.

SQL*Plus: Release 8.0.6.0.0 - Production on Sat Jun 13 21:55:08 2009

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to

Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> SET TIMING ON

SQL> SELECT * FROM DUAL;

D

-

X

Elapsed: 15 -- millisecond mode

SQL*PLUS10.2

In SQL*PLUS 10.2, if you execute the command “set timing on”, when we execute a SQL command , the display of timing statistics’s mode is the normal time mode.

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 13 21:53:39 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> SET TIMING ON

SQL> SELECT * FROM DUAL;

D

-

X

Elapsed: 00: 00: 00.06 -- normal time mode

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10484922/viewspace-1023105/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-18

  • 博文量
    79
  • 访问量
    211211