User does not see the statement details when clicking on the statement in the blocking history dashboard.
The user sets the "Tops" drop down to 1000, but is unable to find the statement in the list.
The blocking situations last several minutes and it is uncertain why the statement does not appear in the SQL Statement dimension list while statement less than one second active time appear, but the statement from the long running block does not appear.
Increase the top number of the dimension tree as per KB 320589.
After this change the batch details can be shown when clicking on the batch in "blocking history".
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center