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
⇒ What Is Oracle Server Autotrace in Oracle
⇐ SQL*Plus Commands Stored in a File in Oracle
2020-06-08, 2443👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MyS...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...