Re: parameter file (init.ora)

Nathan D. Hughes wrote:
>
> Someone <tsbsps_at_istar.ca> writes:
>
> >Pete Desnoyers wrote:
> >>
> >> Where can I get a list of ALL the parameters and their possible values
> >> in the parameter file?
> >>
> >> --
> >> >>>>>> Pete <<<<<<
> >> http://jerry.engrs.infi.net
 

> >Uhhhhh, in the reference manual!? I take it you don't have a set of
> >manuals?
>
> Well, with the emphasis on ALL, I'm assuming he meant documented and
> undocumented parameters. Try x$ksppi.

It might be easier to use v$parameter, which is a public synonym and does not need special permissions.

HTH

-- 
Chrysalis

FABRICATI DIEM, PVNC
('To Protect and to Serve')
Terry Pratchett : "Guards Guards"