TimingStatisticsInDifferentSqlplusVersion

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10484922/viewspace-1023105/