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,

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-l
Received on Mon Jun 13 2022 - 12:35:37 CEST

Original text of this message