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
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to：
Oracle Database
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
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database
SQL> SET TIMING ON
SQL> SELECT * FROM DUAL;
D
-
X
Elapsed: 00: 00: 00.06 -- normal time mode
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10484922/viewspace-1023105/ ，如需转载，请注明出处，否则将追究法律责任。
