SHOW

Purpose

Prerequisites

Syntax

where:

ALL	Shows all settings except for ERRORS, PARAMETERS, and SGA.
AUTORECOVERY	Shows whether or not autorecovery is enabled.
CHARWIDTH	Shows the column display width for CHAR data.
COMPATIBILITY	Shows the sessions compatibility mode: V6, V7, or NATIVE.
DATEWIDTH	Shows the column display width for DATE data.
ECHO	Shows whether or not commands from command files are echoed.
ERRORS	Shows the errors generated from the last compilation of a procedure, package, or function, if any. This option displays the line number, column number, and the error message generated. Use the SHOW ERRORS command if line mode error 72 is returned after compiling a package.
	The SET CHARWIDTH command can be used to expand or truncate the display from the SHOW ERRORS command.
INSTANCE	Shows the connect string for the default instance. SHOW INSTANCE returns the value LOCAL if you have not used SET INSTANCE or if you have used the LOCAL option of the SET INSTANCE command.
LOGSOURCE	Shows the current setting for archive log location. Displays DEFAULT if the default setting is in effect, as specified by the LOG_ARCHIVE_DEST initialization parameter.
LONGWIDTH	Shows the column display width for LONG data.
MAXDATA	Shows the maximum data size.
NUMWIDTH	Shows column display width for NUMBER data.
PARAMETERS	Displays the current values for one or more initialization parameters. You can use a string after the command to see a subset of parameters whose names include that string. For example, if you enter:

				SHOW PARAMETERS COUNT 

	you would see:

				NAME   	                       TYPE  	   VALUE 

				-------------------            -------   ----- 

 				db_file_multiblock_read_count  integer    12 

 				spin_count                     integer    0 

	The SHOW PARAMETERS command, without any string following the command, displays all initialization parameters.
RETRIES	Displays the number of retries that will be attempted when restarting an instance in parallel mode. (See the RETRY option in "STARTUP" .)
SERVEROUTPUT	Displays ON if output from stored procedures and functions is enabled. Otherwise, displays OFF. SERVEROUTPUT is reset to OFF if you issue a CONNECT command.
SGA	Displays information about the current instance's System Global Area.
SPOOL	If spooling is enabled, displays the name of the output spool file. Otherwise, displays OFF.
STOPONERROR	Displays whether or not errors encountered during execution of command files should stop execution of the file.
TERMOUT	Shows if output to the terminal is enabled.
TIMING	Shows whether or not the parse, execute, and fetch times (CPU and elapsed) for each SQL statement executed are shown.

Usage Notes

Examples

SHOW TIMING

returns a display such as:

Timing             OFF

SHOW ALL 

returns a display like:

Instance           local 

Spool              OFF 

Timing             OFF 

Termout            ON 

Echo               OFF 

Stoponerror        OFF 

Autorecovery       OFF

Logsource          <default>

Maxdata            20480 

Numwidth           10 

Charwidth          80 

Longwidth          80 

Datewidth          9 

Labwidth           32

Compatibility      NATIVE

Retries            infinite

Server Output      OFF

SHOW SGA 

returns a display like:

Total Shared Global Area         4612820  bytes 

Fixed Size                         36376  bytes 

Variable Size                    4445372  bytes 

Database Buffers                  122880  bytes 

Redo Buffers                        8192  bytes 

SHOW ERRORS PACKAGE BODY name 

returns a display like:

ERRORS FOR PACKAGE BODY name: 

LINE/COL		ERRORS 

---------------------------------------------------------------

...