Re: Dash_wait_chain script resulting into ORA-01489
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 6 Mar 2023 11:15:56 -0500
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
Other related posts: