View the execution time and sp2-0027 errors of an SQL statement in an Oracle database _oracle

Enter Sqlplus
Sql> Set Timing on
Sql>
Sql> Select COUNT (*) from Comm_human_role;
COUNT (*)
----------
866
elapsed:00:00:00.05
The above digital output is: Hours:Minutes:Seconds.Milliseconds
It takes 0.05 seconds to execute, equivalent to 50 milliseconds.
Time if this is the expression: 00:03:235.78
The total time is 235.78 seconds, less than 4 minutes, so the display is 3 minutes (235.78 seconds about 3分钟55.78秒)
#设置屏幕行宽度
Sql>set linesize 190
#设置sqlplus打印执行计划和统计信息
Sql>set Autotrace on
#设置sqlplus打印执行时间
Sql>set Timing on
If the following error occurs in Sqlplus:
Sp2-0027:input is too long (> 2499 characters)-line ignored
A statement that represents an SQL row has exceeded 2,499 characters.
Solve:
In a section of SQL, add "enter",
To ensure that each line does not exceed 2,499 characters, it is good to execute the SQL statement again.