SQL*Plus

Deprecated SQL*Plus Commands in Oracle 11g R2

Leave a Comment / Oracle / By / March 23, 2012 / , ,

This just a short note to point out that the below SQL*Plus commands are deprecated as of Oracle 11g R2, but available in the current release of SQL*Plus for backward compatibility. The documentation states that this may only be available by setting the SQLPLUSCOMPATIBILITY variable in the future releases.  You should modify scripts using obsolete …

Deprecated SQL*Plus Commands in Oracle 11g R2 Read More »

SQL*Plus Feature: TIMING and SET TIMING command

1 Comment / Oracle / By / January 28, 2011 / , , , , , , ,

SET TIMING—one of the most frequently used commands—displays timing statistics on each SQL command or PL/SQL block. What if you want to collect timing statistics for multiple group of statements? TIMING command becomes handy in such situation—one of things that I knew and have forgotten over time. It can be used to collect data to do …

SQL*Plus Feature: TIMING and SET TIMING command Read More »