Re: Higher Read response in 19C
From: Lok P <loknath.73_at_gmail.com>
Date: Sun, 18 Sep 2022 17:44:08 +0530
Message-ID: <CAKna9VYpL9ch3YMDvv4fY+yrWVP6CBrU-jwBtUV1LVNa=C5gPg_at_mail.gmail.com>
Date: Sun, 18 Sep 2022 17:44:08 +0530
Message-ID: <CAKna9VYpL9ch3YMDvv4fY+yrWVP6CBrU-jwBtUV1LVNa=C5gPg_at_mail.gmail.com>
Thank You.
I see DBA_HIST_TEMPSTATXS is blank post migration to 19C not sure why. This
is having the sample populated during 11.2 period snaps though.
In below GIT link , i have put the sql monitor of the sample query which is
spending ~95%+of the time in the "direct path read temp" and runs for 10
hrs+. this used to finish in 2-3 hrs during 11.2 version. I don't have any
sql monitor from 11.2 period though. Note- I replaced the actual table and
column names by dummy names.
https://gist.github.com/oracle9999/57438885f995c3cadde7005b989496a0
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Sep 18 2022 - 14:14:08 CEST