Re: Dash_wait_chain script resulting into ORA-01489
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 6 Mar 2023 11:15:56 -0500
Message-ID: <a6347014-3a22-afb1-ba2e-b48d7f621e27_at_gmail.com>
Date: Mon, 6 Mar 2023 11:15:56 -0500
Message-ID: <a6347014-3a22-afb1-ba2e-b48d7f621e27_at_gmail.com>
On 3/6/23 05:29, Peter Hitchman wrote:
> Hi
> I have no experience of Exadata, but to benefit from asynchronous I/O,
> filesystemio_options usually needs to be set to "SETALL" or "ASYNC",
> unless Exadata does asynchronous I/O regardless.
>
> Or maybe you need more database writers to be able make use of the I/O
> subsystem's sull capacity.
>
> Regards
> Pete
>
>
Peter, Exadata is RAC, using ASM. SETALL is implied. Oracle recognizes ASM storage and "knows" that it can do asynchronous I/O. It sort of OraGPT.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 06 2023 - 17:15:56 CET