The Utilities tab on the Database Analysis drilldown shows the status of running utilities for a database or partition. You can use it to monitor the status and progress of backup, load, rebalance, restore, runstats, crash recovery, and rollforward recovery operations. You can also use it to determine whether a utility is degrading database performance.
All columns available for the Utilities tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.
|
Column |
Description |
|
Completed Units |
The number of work units that have been completed for the current phase. The value is a running count of completed work units. If the value does not increase over a long period of time, this might indicate that a utility is stalled. (A value is not shown for some utilities.) Check the Work Metric column to see the type of unit used, for example bytes or extents. Check the Total Units column to see the total amount of work for a phase. |
|
Curr Seq |
The number of the current phase of a multiphase utility. A number is only shown if a utility contains multiple sequential phases. |
|
ID |
The unique identifier for a utility job. An example of the format that might be used for an ID is userid.jobname . |
|
Invoker |
The invoker type for a utility. One of the following is shown:
|
|
Phase Description |
A description of the work performed during a utility phase. Phase descriptions include Delete, Load, and Redo. |
|
Phase Start Time |
The timestamp for the start of a utility phase. This includes year, month, date, and hour, in that order. |
|
Priority |
Utility priority specifies the amount of relative importance of a throttled utility with respect to its throttled peers. A priority of 0 implies that a utility is executing unthrottled . Non-zero priorities must fall in the range of 1-100, with 100 representing the highest priority and 1 representing the lowest. |
|
Start |
The timestamp for the time a utility was invoked. This includes year, month, date, and hour, in that order. |
|
State |
The current state of a utility. One of the following is shown:
|
|
Total Units |
The total number of work units in a phase. A value is not shown for some utilities. It is continuously updated for utilities that cannot quantify the total amount of work. Check the Work Metric column to see the type of unit used, for example, bytes or extents. |
|
Type |
The class of a utility. One of the following is shown:
|
|
Utility Description |
A description of the work being performed by a utility. The format used for a description depends on a utility's class. For example, the description for rebalancer might read "Tablespace ID: 3" to indicate that a rebalancer is working on a tablespace with an ID of 3. |
|
Work Metric |
The type of unit used to measure completed work and total work for a utility. Possible units include bytes and extents. A value is not shown for some utilities. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
