#!/bin/sh
#
#  _params      - Display hidden Oracle parameters (Oracle8 & later releases)
#                 Optionally display parameters matching the first argument
#
#  Author: Allan Packer
#  Copyright: Sun Microsystems Inc
#
 
if test $# -gt 1; then
        echo "usage: $0 [parameter name]"
        exit 1
fi
 
if test -n "$1"; then
        predicate="and a.ksppinm like '%$1%'"
else
        predicate=""
fi
 
(
sqlplus -s "/ as sysdba" << EOF
set pagesize 20000
set linesize 20000
select a.ksppinm "name", a.ksppdesc "description", b.ksppstvl "current",
	b.ksppstdf "isdefault"
     from x\$ksppi a, x\$ksppcv b
     where a.indx = b.indx and substr(a.ksppinm,1,1) = '_' $predicate
     order by a.ksppinm;
EOF
) | nawk '{
        if ($0 ~ "rows selected") print $0
        else {
                if (NF == 2) printf("%-45.45s%-25.25s%-9.9s\n", $1, " ", $2)
                else printf("%-45.45s%-25.25s%-9.9s\n", $1, $2, $3)
        }
}'