cpu_cost oracle document 12.2 different between PLAN_TABLE and DBA_HIST_SQL_PLAN
From: milist ujang <ujang.milist_at_gmail.com>
Date: Tue, 25 Feb 2020 17:26:07 +0700
Message-ID: <CACG9ogyr2VOg9uszWwMZndjeyqYm8Nq6ktyaz5z7QGy7gKgy3w_at_mail.gmail.com>
Hi all,
Date: Tue, 25 Feb 2020 17:26:07 +0700
Message-ID: <CACG9ogyr2VOg9uszWwMZndjeyqYm8Nq6ktyaz5z7QGy7gKgy3w_at_mail.gmail.com>
Hi all,
In oracle document, there is different description on cpu_cost column on those 2 views.
Is DBA_HIST_SQL_PLAN table description more precise about cpu cycles?
'
In DBA_HIST_SQL_PLAN, the cpu cost are there for each operation, so how can
we calculate cpu cycle for the query? is it sum up all those cpu_cost's
operation or just take from the top only?
thanks
-- regards ujang jaenudin | DBA Consultant (Freelancer) http://ora62.wordpress.com http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 25 2020 - 11:26:07 CET