Query ASH for Undo Blocks
From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Mon, 13 Jun 2022 12:35:37 +0200
Message-ID: <7b2d74dc-8b53-4fa1-f897-60594258a1af_at_bluewin.ch>
Hi,
Date: Mon, 13 Jun 2022 12:35:37 +0200
Message-ID: <7b2d74dc-8b53-4fa1-f897-60594258a1af_at_bluewin.ch>
Hi,
there is a plan with an Index Range scan that generates way more
buffer_gets than you would expect.
Would it be correct to query active session history using CURRENT_FILE#
and CURRENT_BLOCK# to check against DBA_EXTENTS
to find out if some buffer gets are coming from undo?
The query does work, but i am not sure if the result is showing the
indented answer.
Thanks
Lothar
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 13 2022 - 12:35:37 CEST