Re: Bad Tuning, need to reset spfile

Your advice worked, thanks, I can finally get a good nights sleep.

> Ability to dynamically set parameters in 9i DOES NOT mean that it is
> the only option available to set parameters. Oracle is generally very
> good with keeping things backward compatable. Pick one of these
> options,
>
> 1) Set parameters dynamically with scope=spfile
> 2) Edit pfile, shutdown database and recreate spfile from pfile then
> startup
> 3) Startup using spfile
> 4) Startup using pfile
>
> > Thanks in advance!! By the way, is tuning more of an art than a
> > science?
>
> Don't know if it is more of an art then science but one thing is
> certain... You must have good to excellent knowledge of Oracle RDBMS
> and underlying operating system before embarking on performance
> tuning.
>
> Regards
> /Rauf Sarwar
Received on Sun Jun 08 2003 - 18:07:49 CEST