Monitor and manage database threadsactivities

To open a database threadactivity report, click the Databases tab on the Databases page, then click the database for which you want to view a report. Next, click the ThreadsActivities tab to display the report.

Tip: To view the full report, you might have to collapse the panel on the Databases page.

When you open the Databases page as an administrator, you can see a list of all databases running in your environment. When you attempt to open a database threadactivity report, Planning Analytics attempts to authenticate you as an administrator on the selected database using the same username and password you used to log into Planning Analytics. If your administrator credentials on the selected database are different from those you used to log into Planning Analytics, authentication will fail and you'll be prompted to provide a valid administrator username and password for the database.

A database threadactivity report provides details on every threadactivity on your database, in table format. You can't change the column widths in the report, but you can hover over any item in the report to see the full value.

You can search for multiple words on the ThreadsActivities tab. Separate each word with a comma. For example, run,admin,Architect. Search is not case-sensitive.

For each threadactivity you can view these details:

ID

The unique numeric ID of the thread.

Session ID

The unique numeric ID of the session.

Activity ID

The unique identifier for the running job. This column is not displayed by default. To display it, click and enable the Activity ID option.

Name

The name of the user who initiated the threadactivity.

State

The current threadactivity state.

• Idle: not using resources
• Wait: waiting on other threadsactivities, blocked
• Running
• Commit: committing updates made by a threadan activity
• Rollback: rolling back to a state before an update
• Login: when a user logs in and initiates a threadan activity

Type

Indicates a User or System threadactivity.

Function

The API function being executed by the threadactivity.

Wait

The length of time, in seconds, that the threadactivity has been in a wait state.

Elapsed

The total elapsed time of the threadactivity in its current state.

W/R/Ix locks

The number of write, read, and intent-to-write locks that the threadactivity holds.

A write lock allows only the threadactivity that holds the lock to access and write changes to an object. No other threadactivity can read or modify the object until the W lock has been released.

A read lock allows many threadsactivities to read from an object at the same time, but does not allow another threadactivity to modify or write to the object until all R locks have been released.

An intent-to-write lock reserves the right for a threadan activity to obtain a write lock on an object when all read locks have been released. Only one threadactivity at a time is allowed to have an Ix lock on an object.

Context

The connected Planning Analytics client that is associated with the threadactivity.

Info

When a thread is in a wait state, this column displays the ThreadID of the thread that is blocking the waiting thread.

Description

When an activity is in a wait state, this column displays the Activity ID of the activity that is blocking the waiting activity.

Object name

The name of the object upon which the threadactivity is operating.

Object type

The type of object upon which the threadactivity is operating.

You can click to selectively hide or show any of these columns in your report. The column display configuration is retained between sessions. The next time you open a threadan activity report for any database, you'll see the same columns.

You can copy key activity details to your clipboard for documentation or sharing purposes. To copy a session ID, activity ID, or description, click the overflow menu for any activity in the list and select the specific copy option you need. The system immediately copies the selected detail to your clipboard.