When viewing Oracle blocking, the SQL Text is not seen for the blocking query
说明
When a blocking condition is present in Oracle monitoring the SQL text is only displayed for the blocked query, but not for the blocking one. This is seen in both SQL PI (Blocking History tab) and Activity | Locks dashboard.
解决办法
This has been logged in the Release Notes as a known issue.