All Forums Viewpoint
Kishore_1 208 posts Joined 03/10
19 Dec 2015
Monitor Partition

We are getting alert- Check for a system hang on the monitor partition.  VP was unable to collect data for SQL Explain info.
Is there any query to identify system is hung due to a particular session and corresponding partition?

Fred 1096 posts Joined 08/04
21 Dec 2015

You can query DBC.SessionInfoV to see which sessions are currently logged on to the Monitor partition. There is a limit to the number of Monitor sessions allowed per PE (IFPNo in SessionInfoV).

You must sign in to leave a comment.