Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, August 22, 2007

Script for Oracle init.ora undocumented _parameter values

SET ECHO off
REM NAME: TFSXPARA.SQL
REM USAGE:"@path/tfsxpara"
REM ------------------------------------------------------------------------
REM REQUIREMENTS:
REM Must be run as SYS
REM ------------------------------------------------------------------------
REM AUTHOR:
REM Craig A. Shallahamer / Rick Minutella
REM (c)1994 Oracle Corporation
REM ------------------------------------------------------------------------
REM PURPOSE:
REM Lists the parameter values associated with the instance running
REM the currently opened database.
REM
REM In addition to the normal output of show parameters, this script
REM reports the undocumented parameters from the X$KPPI/X$KSPPCV tables.
REM Most of these parameters are undocumented for a very good reason!
REM They are subject to change or disappear in new releases without
REM notice. Making any changes without the advice of Worldwide
REM Support is not advised and may cause performance degradation or
REM damage to your database.
REM ------------------------------------------------------------------------
REM DISCLAIMER:
REM This script is provided for educational purposes only. It is NOT
REM supported by Oracle World Wide Technical Support.
REM The script has been tested and appears to work as intended.
REM You should always run new scripts on a test instance initially.
REM ------------------------------------------------------------------------
REM Main text of script follows:


ttitle -
center 'All Instance Parameters' skip 2

col ksppinm format a28 heading 'Parameter' justify c trunc
col ksppstvl format a40 heading 'Value' justify c trunc
col ksppstdf format a8 heading 'Default?' justify c trunc

select
a.ksppinm,
b.ksppstvl,
b.ksppstdf
from
x$ksppi a, x$ksppcv b
where a.indx = b.indx
order by a.ksppinm
/

No comments: