Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: intermittent very high waits in LGWR on Linux?
Holger Baer wrote:
> > So
> > "32 rows selected." indicates pain?
>
> Not really. All changes Nuno suggested can be made using
> SQL*Plus (logged in as sysdba) using the following
> syntax:
>
> SQL> alter system set <parametername here> = <value here> scope = spfile;
>
> After you're done changing the parameters, issue
> SQL> create pfile from spfile;
>
> this gives you a nice and handy pfile in case you need it. And then you're
> ready to
> SQL> startup force
> which will shutdown the database and start it again, using the new parameters.
>
and don't forget to plonk here the contents of your brand new "pfile" (edited for Usenet) so we can peek at it and see if there is anything else going "clunk". Received on Thu Jun 30 2005 - 18:44:16 CDT