Showing server parameters in 8i

From: Kevin O'Gorman <kevin_at_trixie.kosman.via.ayuda.com>
Date: Wed, 01 Dec 1999 11:12:38 -0800
Message-ID: <38457326.944717AC@trixie.kosman.via.ayuda.com>

The version of SQL*Plus that comes with 8.1.5 has this neat 'SHOW PARAMETERS' command that shows the server parameters.

One oddity is that it is limited to the first 20 characters of string parameters even if I change the format of the column.

Is there some way of getting the full value of a server's parameters? Like maybe a system view I don't know about?

Thanks...

--
Kevin O'Gorman (805) 650-6274 kogorman_at_pacbell.net At school: kogorman_at_cs.ucsb.edu
Permanent e-mail forwarder: Kevin.O'Gorman.64_at_Alum.Dartmouth.org Received on Wed Dec 01 1999 - 13:12:38 CST