11g ADDM reporting benefits in number of sessions and percent of activity
Hi All ,
In 11g ADDM the benefits are reported in terms of number of sessions and percent of activity
11g ADDM
Impact is 2.07 active sessions, 60.74% of total activity.
---------------------------------------------------------
SQL statements consuming significant database time were found.
whereas in 10g ADDM it was reported in percentage impact and seconds
10g ADDM
My question is what is the rationale behind this shift ?
Can we have some configuration changes in 11g and get back the benefits in seconds, as was in 10g
In 11g ADDM the benefits are reported in terms of number of sessions and percent of activity
11g ADDM
Impact is 2.07 active sessions, 60.74% of total activity.
---------------------------------------------------------
SQL statements consuming significant database time were found.
whereas in 10g ADDM it was reported in percentage impact and seconds
10g ADDM
FINDING 1: 31% impact (7798 seconds)
------------------------------------
SQL statements were not shared due to the usage of literals. This resulted in additional hard parses which were consuming significant database time.
My question is what is the rationale behind this shift ?
Can we have some configuration changes in 11g and get back the benefits in seconds, as was in 10g
0