SQL Text is not seen for the blocking session in Oracle SQL PI
説明
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.
原因
SQL PI cannot capture the SQL Text for a blocking session.
対策
WORKAROUND None
STATUS This is listed as known issue in the release notes PIFOG-405. Defect ID FOG-3721 has been logged to review this issue for feature improvement in a future release of the Oracle cartridge.