Re: Strange problem
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 1 May 2017 00:34:02 -0400
Message-ID: <935a7e5a-a44d-87d9-f401-1498ae99b7f8_at_gmail.com>
Date: Mon, 1 May 2017 00:34:02 -0400
Message-ID: <935a7e5a-a44d-87d9-f401-1498ae99b7f8_at_gmail.com>
On 04/30/2017 06:13 PM, fairlie.rego_at_gmail.com wrote:
> Are you seeing this behaviour if you set
>
> _datafile_write_errors_crash_instance = FALSE (not default) since this
> is what I do
>
> Thanks
> Fairlie
Hi Fairlie,
I haven't tried that, but I will. Thanks for the advice. For now, I've set filesystemio_options to none, increased the number of db_writer_processes to 2 and dbwr_slaves to 4. What I did notice is the expected increased consumption of memory, since the blocks are now cached in the buffer cache. The nightly batch is still running, the night is still young.
Regards
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 01 2017 - 06:34:02 CEST