SET TIME和SET TIMING是SQL*Plus中的命令，用于控制命令提示符前的时间显示和SQL命令执行的计时统计。TIME开启会显示当前时间，TIMING开启则会在每个SQL命令或PL/SQL块运行后显示计时统计。计时统计格式依赖于操作系统，如Linux和Windows显示小时、分钟、秒和百分之一秒。
SET TI[ME] {ON | OFF}
Controls the display of the current time. ON displays the current time before each command prompt. OFF suppresses the time display.
SET TIMI[NG] {ON | OFF}
Controls the display of timing statistics.
ON displays timing statistics on each SQL command or PL/SQL block run. OFF suppresses timing of each command.
See TIMING for information on timing multiple commands.
Example
The format of timing statistic
最低0.47元/天 解锁文章
扫一扫
338
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
