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, 3662🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...