-
Notifications
You must be signed in to change notification settings - Fork 29
/
Copy pathChangelog.txt
135 lines (116 loc) · 6.93 KB
/
Changelog.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
Changelog
=========
I suggest to rely on Github for details about code changes, this will only be a macro about "functionalities"
Was supposed to start on day 1, better late than never no? :-)
v1801
=====
1. Added "clean" DDL script, to be used with set_stats to implement a very simple TC
2. Disable SET ARRAY to prevent issues with 12.2 SQL*Plus
3. Timescale now configurable between seconds and ms (only for AWR reports)
4. Fixed lack of ability to disable raw ASH under plan analysis drill down page
5. Added summary report for non sharing reason (same as https://carlos-sierra.net/2017/09/01/poors-man-script-to-summarize-reasons-why-cursors-are-not-shared/)
6. Added Table/Index/LOB partition info reports
7. Changed named of SQL Monitor reports (name is sql_exec_start in YYYYMMDDHH24MISS format) so they are easier to spot
v1710
=====
1. sqld360_driver.sql now includes time to support concurrent executions (already supported, just prevets annoying error)
2. SQLd360 now accepts custom configuration file as 3rd parameter (provided mini.sql as example of config to reduce collection time)
3. Fixed bug on plan tree heatmap that showed wrong subtree impact numbers
4. New double Y-xis chart with sharable memory vs child cursors report from AWR, helps spot memory usage by HVC
5. New AWR reports organized by total, delta and rolling window time (last 1 day, hardcoded for now)
v1709
=====
1. Remove limit of 15 on Top N reports, now they report the whole set
2. Slightly changed SQLs on DBA_OBJECTS and DBA_SEGMENTS to include LOBs too
3. Fixed bug on Bind List from Memory
4. Changed logic in reports Elapsed Time for ... Executions to better handle "dirty" ASH data (PHV 0)
5. Fixed bug on plan reporting duplicate lines in case of obsolete cursors not cleaned up
v1708
=====
1. Rounded number to 6th decimal digit instead of truncate to 3rd
2. Added V$INMEMORY_FASTSTART_AREA
3. Added formatted SQL report & reshuffled Identification section for better readability
4. ASH samples from HIST don't have a 10s hardcoded value anymore, value is based on _ash parameters (10s anyway in most cases)
5. When execution triggered from eDB360 executed in CDB, SQLd360 switches dynamically to PDB-specific SQL executions
6. Standalone script to set statistics, to be used in a separate environment (like TC)
7. Added detail page on captured bind, both over time (NUMBER and DATE only) and aggregated (all datatypes)
8. Fixed bug on report SQL Execute Time (wrongly accounting overall system time in some cases)
9. Adjusted algorithm to compute object dependencies (trying to miss less objects)
10. Added info about LOBs
v1707
=====
1. Introduced parameter to skip CBO environment
2. Add plan with rowsource stats from SQL Monitoring under "Top N" reports
v1706
=====
1. Changed color scheme and logo
2. Fixed bug in Top N execution, IO bytes
3. Fixed bug on ASH extract expecting ASH.SQL_FULL_PLAN_HASH_VALUE in 12.1.0.1
v1705
=====
1. Fixed bug in Top 15 wait events
2. Introduced plan with substree to Top N executions
3. Improved algorithm for node color collapsed / expand
v1704
=====
1. Fixed bug on Plan Details -> IO Bytes from ASH
2. Fixed bug on Raw ASH for recursive SQLs
3. Plan Tree collapse now adjust the color of the collpased node to include all its children
4. New report showing number of distinct sessions executing the SQL, helps in tracking down short-lived sessions / frequent logons
5. Reduced number of STA run reported
v1703
=====
1. Introduced SUBSTR around low/high_value conversion to avoid SQL*Plus crashing with spurious raw data
2. Moved most of the SQL to q'[]' notation (internal improvement, no user impact)
3. Introduced subtree impact on plan tree, will keep both plan trees in place for some time
4. New standalone script sqld360_create_sql_baseline.sql to help creating baselines from existing plans
v1702
=====
1. Added "trend" line to avg X/exec reports (section 4b)
2. Fixed bug that prevented low/high value translation from being turned off
3. Fixed bug that caused Top N executions under Plan Details to show data for slaves that never joined execution as "standalone"
4. Removed Style column from HTML reports
v1701
=====
1. Changed a few charts parameter to make it nicer during copy&paste
2. Added new observation on num_rows = 0 at some point in the same, implemented using MATCH_RECOGNIZE
3. Put back the CLEAR COL at the beginning of SQLd360 execution
v1624
=====
1. Added column SQL_FULL_PLAN_HASH_VALUE
2. Translated virtual column into underlying expression in histogram page for expressions
v1623
=====
1. Added SQL Tuning Advisor section to column 5, will only report on past tasks, won't run STA for the SQL (like SQLT does)
2. Modified report Buffer gets/row/execution to keep just buffer gets/row (dropping executions)
3. Fixed bug on report Top 15 Step/Wait/Object where the sorting was on the wrong column
4. Fixed bug on SQL Performance Summary
5. Added script to extract basic table stats
v1622
=====
1. Raw ASH includes data for SQL with TOP_LEVEL_SQL_ID equals to the seeded one and SQL_ID different than that, goal is to capture recursive (enabled only when SQL spends time on PL/SQL)
2. SQLd360 stops executing when it consumed all the time allocated by eDB360 (the *next* SQL ID will be ignored, the current will be complete)
3. Added label to many bar charts that were missing it
4. Added plan in txt format to Plan Details page
5. Added SQL Patch to SQL Performance Summary
v1621
=====
1. Added support for Materialized Views under Object and Metadata section
2. Replaced pie charts with bar charts, easier to show differences in size
3. Modified charts to show similar colors to EM when dealing with wait events / wait classes
4. Removed calls to procedure DBMS_STATS.CONVERT_RAW inserting result into the plan_table, replaced with inline calls to functions in UTL_RAW
5. Added Observation on redundant indexes
6. Modified SQL Plan Directives SQL to support DS results stored in SPD (new in 12.2)
7. Added new report under In-Memory section (some new in 12.2)
8. Modified formula for "Elapsed time per .. execution" removing the LEAST(max-min, count) to be just max-min (not sure why it was the other way around)
9. Fixed bug on Partition Statistics History
v1620
=====
1. Introduced limit (configurable) to number of plans to focus on unde Plan Details page. Plans are selected based on the amount of data we have for each of them
2. Disabled by default the usage of v$object_dependency to build list of tables (too much unnecessary info brought over)
3. Disabled SQL_TRACE for SQLd360 execution itself, never used so why doing it in the first place.
4. Replaced list of tables stored in SQLPlus variable with rows into plan_table, allows to handle long list (SQLPlus variable is max 3k chars)
5. Added USER_ID into from ASH, included in Raw ASH and List of executions from ASH reports
6. Added Raw ASH into to Top SQL executions under Plan Details
7. Added report Average buffer gets per row per execution per Plan Hash Value from AWR, will help spot "bad plans on paper"
8. Minor cosmetic changes