Collections:
Use SQL*Plus Built-in Timer in Oracle
How To Use SQL*Plus Built-in Timers in Oracle?
✍: FYIcenter.com
If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands:
The following tutorial exercise shows you a good example of using SQL*Plus built-in timers:
SQL> TIMING START timer_1 (some seconds later) SQL> TIMING START timer_2 (some seconds later) SQL> TIMING START timer_3 (some seconds later) SQL> TIMING SHOW timer_1 timing for: timer_2 Elapsed: 00:00:19.43 (some seconds later) SQL> TIMING STOP timer_2 timing for: timer_2 Elapsed: 00:00:36.32 SQL> TIMING 2 timing elements in use
Â
2020-06-08, 2066👍, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...