Interested in dbscatteredread event, how to drill down it? which session/query is the cause for this, that session can be cancelled/killed ?
You should be able to get to the problem session using the Waiting Events drilldown.
If you connect and navigate to the Waiting Events Drilldown, select the Wait Event of interest – ‘db file scattered read’ you will then see the Current Users\Sessions and a History of SQL related to this event.
You can then use the right-click menu (“Show Session Details”) to select and navigate from the User\Session to the Top Session screen where you can view more detail on the offending session.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center