Re: intermittent very high waits in LGWR on Linux?

bugbear wrote:
> Noons wrote:
>
[snip]

>>
>> select * from v$spparameter
>> where value is not null;
>>
>> If that returns no rows you are using a pfile
>> instead of a spfile and the following is valid.
>> Otherwise, you have to do all the work using
>> Enterprise Manager (and that is another pain...)

> 
> 
> 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.

HTH
Holger Received on Thu Jun 30 2005 - 11:17:07 CDT