This is the fifth in a series of articles.
       View the first article.
       View the series index.

This article describes dialogs, such as SQL/Explain, that are built into the Monitor Object for your immediate use. No coding is required. Simply call one of the 'Show' methods and the information will be retreived and displayed in a simple to read format.

The Cpu and Disk Skew dialog

Use the ShowSkew method of the Session object to display the following dialog:

This dialog provides an indication of how good the parallelism is for the work performed on behalf of this session. It displays the number of AMPs that were involved during the most recent data collection interval, and shows the usage on the  3 most heavily used, and 3 least heavily used, AMPs.

You may also use the SQL button on this dialog to display the SQL text of the current query together with its associated Explain plan.

The SQL and Explain Text dialog

Use the ShowSQL method of the Session object to display the following dialog:

This dialog displays the SQL that is currently being executed by the session, together with the Explain plan that is being executed.
For each step in the plan we display the estimated and/or actual cpu time used and the number of I/Os performed for that step.
Once displayed, the user may press the Refresh button on this dialog to refresh the displayed information.
They may also use the SaveAs button to save the information to a file for future use.

The Query Bands dialog

Use the ShowQueryBands method of the Session object to display the following dialog:

This dialog displays all Queryband values that have been defined for either the current session or for the Transaction that is currently executing.

The Password Expired dialog

This dialog will be displayed automatically if the password used in the Connect method has expired. 
No method exists to manually display this dialog.


Please refer to the Reference Guide for detailed information on the Object Model.

enjoycoding 1 comment Joined 08/10
04 Oct 2010

I have a doubt over this monitoring sessions. Can you please try to answer my question asked here.

You must sign in to leave a comment.