Re: Showing server parameters in 8i

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 01 Dec 1999 20:12:40 +0800
Message-ID: <384510B8.717B@yahoo.com>

Kevin O'Gorman 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...
>
> --
> 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

v$parameter
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 01 1999 - 06:12:40 CST