Base type: System.ExtensionEntity
Summary: Detail Wait Time statistics for DB instance
| Name | Type | Notes |
|---|---|---|
| DatabaseId | System.Int32 | Reference to Orion.DPA.DatabaseInstance.Id |
| GlobalDatabaseId | System.Int32 | Unique ID of database instance in Orion |
| DimensionId | System.Int32 | Detail data-dimension; possible values are: SQL (1), WAIT (2), PROGRAM (3), DATABASE_INSTANCE (4), MACHINE (5), DB_USER (6), OS_USER (7), FILE (8), DRIVE (9), PLAN (10), ACTION (11), MODULE (12), PARTITION (13), OBJECT (14), PROCEDURE (15), SESSION (16) |
| InstanceId | System.String | IDs of an instances in DPA; for programs, machines, users, etc. these are typically generically-generated IDs in local repository table; for SQL texts these are SQL hashes |
| InstanceName | System.String | Name of an instance; e.g. 'IGNITE' (for program), 'administrator-XYZ' (for user), 348A3F21 (for SQL text) |
| TopN | System.Int32 | Limits the maximal number of categories (SQLs, programs etc.) to be retrieved for the specified time interval. Ignored for WAIT dimension if the TimesliceUnit is not provided. If TopN is not specified, default value is the NUMBER_OF_ITEMS_IN_TIMESERIES_CHART attribute in DPA config for the given monitored database instance. |
| InstanceValue | System.String | For SQL time-slice – this field contains full SQL text; For other time-slice dimensions it is empty; For all non time-slice dimensions it contains WAIT cause |
| IntervalUnit | System.Int32 | Allowed values are HOUR (3), TWO_HOURS (30), THREE_HOURS (31), FOUR_HOURS (32), SIX_HOURS (33), EIGHT_HOURS (34), TWELVE_HOURS (35 |
| Time | System.DateTime | Time-stamp of entity record (operators <, <=, > and >= can be used in WHERE clauses on this field) |
| TimesliceUnit | System.Int32 | Specifies how time-frame should be split. Allowed values are (other than ones in IntervalUnit) FIVE_SECONDS (10), TEN_SECONDS (11), FIFTEEN_SECONDS (12), TWENTY_SECONDS (13), THIRTY_SECONDS (14), MINUTE (2), TWO_MINUTES (20), FIVE_MINUTES (21), TEN_MINUTES (22), TWENTY_MINUTES (23), THIRTY_MINUTES (24), TWO_DAYS (40), THREE_DAYS (41) |
| Wait | System.Double | Total wait-time in seconds for each returned record |
| Executions | System.Int32 | Number of Executions for each returned value. Returns 'null' if value is not specified (e.g. Timeslice < 10 min or Dimension <> 1 ), -1 if 'Not Available' (e.g. in Truncate queries), otherwise not negative number |
| Average | System.Double | Average in seconds for each returned value. Returns 'null' if value is not specified (e.g. Timeslice < 10 min or Dimension <> 1 ), -1 if 'Not Available' (e.g. in Truncate queries), otherwise not negative number |
| MachineIdentifier | System.String | Machine identifier |
| AdditionalValue | System.String | |
| DisplayName | System.String | |
| Description | System.String | |
| InstanceType | System.Type | |
| Uri | System.String | |
| InstanceSiteId | System.Int32 | Default='0'. |
| DatabaseInstance | Orion.DPA.DatabaseInstance | Defined by relationship Orion.DatabaseInstanceDetailDataDimension (System.Reference) |