Aw: DBA_INDEX_USAGE
From: <rogel_at_web.de>
Date: Fri, 28 May 2021 19:29:56 +0200
Message-ID: <trinity-00938042-53df-4aef-a930-a60fa971d38f-1622222996366_at_3c-app-webde-bs16>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 28 2021 - 19:29:56 CEST
Date: Fri, 28 May 2021 19:29:56 +0200
Message-ID: <trinity-00938042-53df-4aef-a930-a60fa971d38f-1622222996366_at_3c-app-webde-bs16>
Hi Charlotte,
shot in the dark:
An index can be accessed more than one time during one execution, so those numbers can be different.
Regards,
Matthias
Gesendet: Freitag, 28. Mai 2021 um 19:06 Uhr
Von: "Charlotte Hammond" <dmarc-noreply_at_freelists.org>
An: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
Betreff: DBA_INDEX_USAGE
Von: "Charlotte Hammond" <dmarc-noreply_at_freelists.org>
An: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
Betreff: DBA_INDEX_USAGE
Hello all,
Please could somebody clarify for the me the distinction between these columns in DBA_INDEX_USAGE:
TOTAL_ACCESS_COUNT (Total number of times the index has been accessed)
TOTAL_EXEC_COUNT (Total executions the index has participated in)
How can an index participate in an execution without being accessed? Why are these numbers not the same?
Thank you!
Charlotte