Re: Showing server parameters in 8i

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 01 Dec 1999 15:17:41 -0500
Message-ID: <9i0b4sou3g2huknsv5ak4jrkehc028ee0j@4ax.com>

A copy of this was sent to Kevin O'Gorman <kevin_at_trixie.kosman.via.ayuda.com> (if that email address didn't require changing) On Wed, 01 Dec 1999 11:12:38 -0800, you wrote:

>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...

select * from v$parameter

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Dec 01 1999 - 14:17:41 CST