Re: Undocumented INIT.ORA parameters

From: Bob Poortinga <bobp_at_tsc.com>
Date: 1996/05/03
Message-ID: <318A8E61.1C05_at_tsc.com>#1/1

JP Srinath <jp_at_queen.plaza.nt.com> wrote:
>
> Subject says it all - Any pointers appreciated
>

If you REALLY want to open Pandora's box, here is a query that lists all undocumented INIT.ORA parameters. Setting these parameters to other than the default is NOT recommended, and should be considered a CLM (career limiting move). You are on your own!!!

sqlplus sys/change_on_install

SQL> col init_parameter format 'a40' trunc
SQL> col default_value format 'a35' word_wrapped
SQL> select ksppinm init_parameter, ksppivl default_value

  2 from x$ksppi
  3 where substr(ksppinm,1,1) = '_';

--
Bob Poortinga (mailto:bobp_at_tsc.com, http://www.tsc.com/~bobp/)
Technology Service Corp. (http://www.tsc.com/)
Bloomington, Indiana  USA

Received on Fri May 03 1996 - 00:00:00 CEST