Re: Dash_wait_chain script resulting into ORA-01489
Date: Sat, 4 Mar 2023 00:19:23 +0530
Message-ID: <CAEzWdqe-p4H79D_PqZvEzjfE8JD-f2zjFCwRi-oirsY0f3-Xuw_at_mail.gmail.com>
Thank You Pete. We are not seeing any signs of IO spike or Disk utilization
being saturated in the storage cells during this time. Below are the
database details.
It's Oracle 19c. And Exadata machine.
And also just to note , as I am unable to fetch the dash_wait_chain from
during the exact peak period as it is failing with error 'result
concatenation is too long' , so not sure if the above
supplied dash_wait_chain output from immediate before the issue period is
reliable to what extent.
On Fri, Mar 3, 2023 at 10:16 PM Peter Hitchman <pjhoraclel_at_gmail.com> wrote:
> Hi,
Disk_asynch_io - True, filesystemio_options-None.
Platform- linux X86 64bit, CPU - 96, Cores- 48, Sockets-2.
> I think some more detail about your set-up will help to get some answers:
> Oracle version
> Operating system
> Number of CPUs
> and
> The database I/O configuration (disk_asynch_io and filesystemio_options)
> and the set-up of the storage being used.
>
> I think that this points to the I/O subsystem not being able to keep up
> with the load it is being given.
>
> Regards
> Pete
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 03 2023 - 19:49:23 CET