SQLPLUS Ï¿ÉÒÔÏÔʾsqlÓï¾äÖ´ÐÐʱ¼äµÄÃüÁî

SET TIMING ON | OFF
SQL> set timing on
SQL> select * from emp where empno = 7369;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ----------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 18-DEC-1980 800
20
Elapsed: 00:00:00.04
SQL> set timing off
SQL> /
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ----------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 18-DEC-1980 800
20
SQL> SET TIMING
SP2-0265: timing must be set ON or OFF

½øÈësqlplus
SQL> set timing on
SQL>
SQL> select count(*) from comm_human_role;
COUNT(*)
----------
866
Elapsed: 00:00:00.05
ÒÔÉÏÊý×ÖÊä³ö·Ö±ðÊÇ£ºHours:Minutes:Seconds.Milliseconds
¼´ÓÃÁË0.05ÃëµÄʱ¼äÖ´ÐУ¬Ï൱ÓÚ50ºÁÃë¡£
ʱ¼äÈç¹ûÊÇÕâÑùµÄ±íʾ£º00: 03: 235.78
×ܹ²ÓõÄʱ¼äΪ235.78Ã룬 ²»µ½4·ÖÖÓ£¬ËùÒÔÏÔʾµÄÊÇ3·ÖÖÓ£¨235.78Ãë´óԼΪ3·ÖÖÓ55.78Ã룩
#ÉèÖÃÆÁÄ»Ðпí¶È
SQL>set linesize 190
#ÉèÖÃsqlplus´òÓ¡Ö´Ðмƻ®ºÍͳ¼ÆÐÅÏ¢
SQL>set autotrace on
#ÉèÖÃsqlplus´òÓ¡Ö´ÐÐʱ¼ä
SQL>set timing on
Èç¹ûÔÚsqlplusÖгöÏÖÏÂÃæµÄ´íÎó£º
SP2-0027: Input is too long (> 2499 characters) - line ignored
±íʾsqlÒ»ÐеÄÓï¾äÒѾ­³¬¹ýÁË2499¸ö×Ö·û¡£
½â¾ö£º
ÔÚÒ»¶ÎsqlÖмӓ»Ø³µ”£¬
±£Ö¤Ã¿Ðв»³¬2499¸ö×Ö·û£¬ÖØÐÂÖ´ÐÐsqlÓï¾ä¾ÍºÃÁË
Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/20296.htm