Configuring the Database Monitor

Go Up to Database Monitor

The Database Monitor lets you:

• Toggle to split the screen and display the target process SQL For details, see SQL Toggle.
• Open a SQL window and display the SQL. For details, see ISQL.
• View a Query Plan for SQL running for selected processes. For details, see Query Plan.
• Save custom column-widths on a DBMS platform basis. See Customizing column widths.
• View user session details. See Session Details.

SQL Toggle

DBArtisan lets you split the Database Monitor screen and display the SQL running for selected processes.

1. On the Database Monitor tool bar, click Toggle.

Note: To open a SQL window or view a Query Plan for SQL running on selected processes, you must have your Database Monitor Screen split to display SQL on the bottom.

ISQL

DBArtisan displays the SQL running for selected processes in a SQL Editor. You must turn on the SQL Toggle to display the target SQL in the split screen. To display the SQL in a separate window do the following:

1. On the Database Monitor, click the target process.

   Note: To open a SQL Editor or view a Query Plan for processes, SQL Toggle must be on, displaying the target SQL in the split screen.

2. If SQL Toggle is not on, on the Database Monitor tool bar, click Toggle.
3. On the Database Monitor tool bar, click ISQL.

   DBArtisan opens a SQL window with the target process SQL.

4. To execute the SQL, click the SQL Window tool bar, click Execute.

Query Plan

The Database Monitor lets you view the Query Plan for target processes. To view the Query Plan, do the following:

1. On the Database Monitor, select the target process.

   Note: To open a SQL Editor or view a Query Plan for processes, SQL Toggle must be on, displaying the target SQL in the split screen.

2. If SQL Toggle is not on, on the Database Monitor tool bar, click Toggle.
3. On the Database Monitor tool bar, click Plan.

   DBArtisan executes the SQL with query plan and opens a Results Editor with the results.

Customizing column widths

When you manually resize the width of a column on a Database Monitor tab, the new size is saved across startups of Database Monitor as well as DBArtisan for the current DBMS platform type.

Session Details

Note: The functionality is available for Oracle only.

The Database Monitor lets you view user session details through the User Session Information dialog. Once you open the User Session Information dialog, you can view the SQL associated with the session.

The table below describes the tabs of the User Session Information dialog:

Tab	Description
Statistical Details	Lets you can scroll up and down to see parameters and values.
Waits	Displays either historic or current wait statistics and lets you display or filter out idle wait events. NOTE: Data returned for historic session waits is different than the data returned for current session waits.
Current SQL	Lets you view the SQL for this session.

Completing the Session Details Dialog Box

1. On the Database Monitor tool bar, click Session.

   DBArtisan opens the User Session Information dialog.

2. On the Statistical Details tab, in the Session Parameters grid, you can scroll up and down to see parameters and values.
3. On the Waits tab, view select Historical Waits or Current Waits.
4. Select Include Idle Waits to display idle wait events.
5. On the Current SQL tab, view the SQL for this session.
6. When you finish viewing SQL, click OK.

   DBArtisan returns to the Database Monitor dialog.