Accessing data using public views

data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts can be used to prepare data for a custom view or report. For information about managing data marts, see SQL-based data marts.

Data marts rely on a basic set of views that hide the TrueSight Capacity Optimization data model and expose a more report-oriented view over data, known as public views. The Advanced Reporting module produces a number of public views that can be accessed using the CPIT_REP account (the default database user account for generating reports).

These views let you access relevant TrueSight Capacity Optimization data in a simple and straightforward manner. The following sections describe these views in detail.

To view example queries developed using these public views, see Query Examples.

Public views produced by the Advanced Reporting module

Public views produced by the Advanced Reporting module that can be accessed using the CPIT_REP account are divided into the following categories:

System-related views

PV_SYSTEM

Each System is created by a connector, and it remains in TrueSight Capacity Optimization until either all of its data ages out, or the System and all of its data is explicitly dismissed and deleted by a TrueSight Capacity Optimization user.
This view contains one row for each system, keyed by its unique entity ID (SYSID).

Column Name

Data Type

Description

Key column

SYSID

NUMBER

Internal TrueSight Capacity Optimization-assigned unique identifier

PK

NAME

VARCHAR2 (50 Bytes)

System name assigned by connector or modified by user

 

DESCRIPTION

VARCHAR2 (250 Bytes)

System description

 

SYSTYPEID

NUMBER

The type of the system, assigned by connector. A constant from the list of System types described in "Entity Types".

 

SYSTYPE

VARCHAR2 (50 Bytes)

Type string that goes with SYSTYPEID

 

CLUSTERID

NUMBER

(deprecated) System cluster ID

 

CLUSTERNAME

VARCHAR2 (50 Bytes)

(deprecated) Cluster name

 

CLUSTERTYPE

VARCHAR2 (25 Bytes)

(deprecated) Cluster type

 

CLUSTERDESCRIPTION

VARCHAR2 (250 Bytes)

(deprecated) Cluster description

 

STATUSIDNUMBERStatus ID of the system 

Back to top ↑

PV_SYS_METRIC

This view contains information on metric instances belonging to Systems.

A metric instance contains time-varying data, either as a time series of numbers that can change on a frequent interval, or as a configuration string that changes only occasionally. For more information on metrics and metric instances, see Capacity Agent Metric groups and metrics.

A metric instance is created when data for a particular metric for a System is first loaded by a connector. It remains in TrueSight Capacity Optimization until its owning system is either aged out or dismissed and deleted by a user.

This view does not contain the time series or configuration data itself. Time series data is in the PV_SYS_DATA_DETAIL and similar views. Configuration data is in PV_SYS_CONF_LAST and PV_SYS_CONF_VARIATION views.

This view contains one row per metric instance, keyed by SYSMETRICID.

Column Name

Data Type

Description

Key column

SYSID

NUMBER

The identifier of the System that the metric instance belongs to, as in PV_SYSTEM.

AK1. FK SYSID in PV_SYSTEM

SYSMETRICID

NUMBER

An internal unique TrueSight Capacity Optimization-generated identifier for the metric instance

PK

NAME

VARCHAR2 (50 Bytes)

System name, as in PV_SYSTEM

 

DESCRIPTION

VARCHAR2 (250 Bytes)

Description string that goes with the System, as in PV_SYSTEM

SYSTYPEID

NUMBER

System type ID, as in PV_SYSTEM

 

SYSTYPE

VARCHAR2 (50 Bytes)

Type of the System, as in PV_SYSTEM

 

METRIC

VARCHAR2 (50 Bytes)

Metric name, uniquely identifying the metric of this metric instance

 

METRICNAME

VARCHAR2 (50 Bytes)

Metric full name

 

SUBMETRICNAME

VARCHAR2 (512 Bytes)

Metric sub-object name, valid only for metrics with sub-objects

AK1

LOCATIONID

NUMBER

Location ID for the metric instance, if any; default 0

 

LOCATIONNAME

VARCHAR2 (50 Bytes)

Location name that goes with the location ID, if any; default UNKNOWN

 

VALTYPEID

NUMBER

Value type ID for time series metrics (see table of metric value types). For conf series metrics, the VALTYPEID is always 5. See PV_CAT_VAL_TYPE.

 

VALTYPE

VARCHAR2 (50 Bytes)

Value type (count, rate,..) that goes with the Value type ID

 

The 5-tuple structure of a metric instance listed in Capacity Agent Metric groups and metrics is a synonym table for the above view, with key series attributes corresponding to the above column names as follows:

Key series attribute

Column name

ENTITY

SYSID

ENTCATNM

Not listed (it is always the constant "SYS")

OBJECT

METRIC

SUBOBJECT

SUBMETRICNAME

LOCATION

LOCATIONID

This table shows how connector data corresponds to the public view.

Back to top ↑

PV_SYS_EVENT

This view contains information on system events.

Column Name

Data Type

Description

SYSDESC

VARCHAR2 (4000 Bytes)

 

SYSTYPEID

NUMBER

 

SYSTYPE

VARCHAR2 (50 Bytes)

 

CLUSTERID

NUMBER

 

CLUSTERNAME

VARCHAR2 (50 Bytes)

 

CLUSTERTYPE

VARCHAR2 (25 Bytes)

 

CLUSTERDESCRIPTION

VARCHAR2 (250 Bytes)

 

TS

DATE

Timestamp

EVENTTYPEID

NUMBER

 

EVENTTYPENAME

VARCHAR2 (50 Bytes)

 

EVENTSUBTYPEID

NUMBER

 

EVENTSUBTYPENAME

VARCHAR2 (50 Bytes)

 

EVENTID

NUMBER

 

EVENTTS

DATE

 

INTERVENTTS

DATE

 

RESOLUTIONTS

DATE

 

EVENTNAME

VARCHAR2 (250 Bytes)

 

EVENTDESC

VARCHAR2 (4000 Bytes)

 

NOTE

VARCHAR2 (4000 Bytes)

 

COLOR

VARCHAR2 (50 Bytes)

 

PERIOD

NUMBER

 

PERIODSINCEDATE

DATE

 

PERIODTODATE

DATE

 

SEVERITY

VARCHAR2 (50 Bytes)

 

STATUS

VARCHAR2 (50 Bytes)

 

SERVICEUNAVAILABILITY

NUMBER

 

PENDINGTIMEMILLIS

NUMBER

 

INTERVENTTIMEMILLIS

NUMBER

 

RESOLUTIONTIMEMILLIS

NUMBER

 

SOURCECLASS

VARCHAR2 (512 Bytes)

 

SRCEVENTID

VARCHAR2 (50 Bytes)

 

COUNTOCCURRENCE

NUMBER

 

SYSID

NUMBER

 

SYSNAME

VARCHAR2 (250 Bytes)

 

Back to top ↑

PV_SYS_METRIC_EVENT

This view contains information on events owned by system metrics.

Column Name

Data Type

Description

TS

DATE

Timestamp

EVENTTYPEID

NUMBER

 

EVENTTYPENAME

VARCHAR2 (50 Bytes)

 

EVENTSUBTYPEID

NUMBER

 

EVENTSUBTYPENAME

VARCHAR2 (50 Bytes)

 

EVENTID

NUMBER

 

EVENTTS

DATE

 

INTERVENTTS

DATE

 

RESOLUTIONTS

DATE)

 

EVENTNAME

VARCHAR2 (250 Bytes)

 

EVENTDESC

VARCHAR2 (4000 Bytes)

 

NOTE

VARCHAR2 (4000 Bytes)

 

COLOR

VARCHAR2 (50 Bytes)

 

PERIOD

NUMBER

 

PERIODSINCEDATE

DATE

 

PERIODTODATE

DATE

 

SEVERITY

VARCHAR2 (50 Bytes)

 

STATUS

VARCHAR2 (50 Bytes)

 

SERVICEUNAVAILABILITY

NUMBER

 

PENDINGTIMEMILLIS

NUMBER

 

INTERVENTTIMEMILLIS

NUMBER)

 

RESOLUTIONTIMEMILLIS

NUMBER

 

SOURCECLASS

VARCHAR2 (512 Bytes)

 

SRCEVENTID

VARCHAR2 (50 Bytes)

 

COUNTOCCURRENCE

NUMBER

 

SYSID

NUMBER

 

SYSMETRICID

NUMBER

 

SYSNAME

VARCHAR2 (250 Bytes)

 

SYSDESC

VARCHAR2 (4000 Bytes)

 

SYSTYPEID

NUMBER (22 Bytes)

 

SYSTYPE

VARCHAR2 (50 Bytes)

 

METRIC

VARCHAR2 (50 Bytes)

 

METRICNAME

VARCHAR2 (250 Bytes)

 

SUBMETRICNAME

VARCHAR2 (512 Bytes)

 

Back to top ↑

PV_SYS_CONF_VARIATION

This view describes historical changes in configuration metric instances (CONF). See how CONF metrics are recorded in TrueSight Capacity Optimization, in the page Capacity Agent Metric groups and metrics.

This view shows every past value of each configuration metric instance. If you are trying to extract the current values of configuration metric instances, you probably want to use the view PV_SYS_CONF_LAST below. That view contains only the last value of the configuration parameters.

The key column in this view is SYSMETRICID, which is an internal TrueSight Capacity Optimization-generated unique number assigned to each metric instance.

Column Name

Data Type

Description

Key column

SYSMETRICID

NUMBER

System metric ID

PK. FK for SYSMETRICID in PV_SYS_METRIC

SINCEDATA

DATE

Value validity start day

PK

TODATE

DATE

Value validity end day

 

VALUE

VARCHAR2

Metric value

 

To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_NUM'

Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

Apart from the changes in system configuration metrics values, if you want to check the historical changes in workload configuration metrics you can use PV_BDRV_CONF_VARIATION view.

Back to top ↑

PV_SYS_CONF_LAST

This view reports only the last value of system configuration metric instances.

See how CONF metrics are recorded in TrueSight Capacity Optimization, in the page Capacity Agent Metric groups and metrics.

If you are looking for past values, use the view PV_SYS_CONF_VARIATION above.

The key column is SYSMETRICID, which is an internal TrueSight Capacity Optimization-generated unique number assigned to each metric instance.

Column Name

Data Type

Description

Key column

SYSMETRICID

NUMBER

System metric ID

PK

SINCEDATE

DATE

Value validity start day

 

TODATE

DATE

Value validity end day

 

VALUE

VARCHAR2

Metric value

 

INSERTTS

DATE

Timestamp of insertion of this row. This is when the metric instance was created, or when the metric value was last changed.

 

UPDATETS

DATE

Timestamp of last update on this row. This is when the metric instance value shown in this row was last loaded by a connector.

 

To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_NUM'

Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

Apart from the last value of system configuration metric if you want to check the last value of workload configuration metrics you can use PV_BDRV_CONF_LAST view.

Back to top ↑

PV_SYS_DATA_DETAIL

This view contains system data in its original state. It does not have any default resolution.

The key column for this view is SYSMETRICID, which is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

Column Name

Data Type

Description

Key column

SYSMETRICID

NUMBER

System metric ID

PK

TS

DATE

Timestamp

PK

DCLASSID

NUMBER

The Day class ID refers to the day for which statistics are calculated.

 

HCLASSID

NUMBER

If hour classes are defined, the Hour class ID refers to individual classes for which statistics are calculated.

For example, you can categorize a day into three classes (in hours) that signify work shifts.

 

DURATION

NUMBER

Interval duration [seconds]

 

AVGVALUE

NUMBER

Average samples value in the interval.

 

MINVALUE

NUMBER

Minimum sample value in the interval.

 

MAXVALUE

NUMBER

Maximum sample value in the interval.

 

SUMVALUE

NUMBER

Sum of samples values in the interval.

 

SUMQUADVALUE

NUMBER

Sum of samples square values in the interval.

 

COUNTGOOD

NUMBER

Number of samples in the interval with good value.

 

COUNTWARN

NUMBER

Number of samples in the interval with warning value.

 

COUNTPOOR

NUMBER

Number of samples in the interval with poor value.

 

COUNTERROR

NUMBER

Number of erroneous samples in the interval.

 

COUNTVALUE

NUMBER

Number of samples in the interval.

 

WEIGHT

NUMBER

Weight related to resource value. When no value is specified, the default value is 1.

 

WAVGVALUE

NUMBER

Weighted average value.

 

The recommended aggregation to preserve data semantics in this view is explained in the following code:

 SUM(duration) AS duration,
 DECODE(SUM(duration),0,0,SUM(avgvalue*duration)/SUM(duration)) AS avgvalue,
 MIN(minvalue) AS minvalue,
 MAX(maxvalue) AS maxvalue,
 SUM(sumvalue) AS sumvalue,
 SUM(sumquadvalue) AS sumquadvalue,
 SUM(countgood) AS countgood,
 SUM(countwarn) AS countwarn,
 SUM(countpoor) AS countpoor,
 SUM(counterror) AS counterror,
 SUM(countvalue) AS countvalue,
 SUM(weight) AS weight,
 DECODE(SUM(weight),0,0,SUM(wavgvalue*weight)/SUM(weight)) AS wavgvalue,

In order to compute the variance of data samples, you can apply the following statement to the result of a time aggregation query:

decode(countvalue,1,0,
(sumquadvalue/(countvalue-1)-power(avgvalue,2)*countvalue/(countvalue-1))

Back to top ↑

PV_SYS_DATA_DH

This view contains system data at hourly resolution, So for given date there will be 24 rows for given sysmetricid.This view has the structure of, and uses the same aggregation recommended for and present in the .Accessing data using public views v11.3.01 view.

The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.

Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

TS is the timestamp of the of the value available for metric instance.

DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition.This can be used for filtering purposes i.e. to consider/exclude set of day classes.

PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.

when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour

ts

plclass

value

duration

00:00

normal (pclassid=0)

10

3300

00:00

outlier

10000000

300

To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

Back to top ↑

PV_SYS_DATA_D

This view contains system data at daily resolution. This view has the same structure of, and uses the same aggregation as present in the PV_SYS_DATA_DETAIL view.

The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.

Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

TS is the timestamp of the of the value available for metric instance.

DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition.This can be used for filtering purposes i.e. to consider/exclude set of day classes.

PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.

when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour

ts

plclass

value

duration

00:00

normal (pclassid=0)

10

3300

00:00

outlier

10000000

300

To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

Back to top ↑

PV_SYS_DATA_DAY

Column Name

Data Type

SYSMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_SYS_DATA_MDCH

This contains system data at monthly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.

The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.

Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

TS is the timestamp of the of the value available for metric instance.

DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition.This can be used for filtering purposes i.e. to consider/exclude set of day classes.

PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.

when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour

ts

plclass

value

duration

00:00

normal (pclassid=0)

10

3300

00:00

outlier

10000000

300

To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

For example, select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

Back to top ↑

PV_SYS_DATA_RAW

This view contains system data at its original resolution. No time aggregation is performed on this. This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.

The key columns for this view are SYSMETRICID and TS.

Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

TS is the timestamp of the of the value available for metric instance.

To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

Back to top ↑

PV_SYS_DATA_CUST_STAT

Column Name

Data Type

Description

SYSOBJID

NUMBER

 

STATID

NUMBER

 

TS

DATE

Timestamp

VALUE

NUMBER

 

COUNTSAMPLE

NUMBER

 

STATPRODID

NUMBER)

 

STRINGVALUE

VARCHAR2 (250 Bytes)

 

NAME

VARCHAR2 (50 Bytes)

 

DESCRIPTION

VARCHAR2 (250 Bytes)

 

VALTYPEID

NUMBER

See PV_CAT_VAL_TYPE.

OWNERSHIP

NUMBER

 

PV_SYS_DATA_DETAIL_EXOU

Column Name

Data Type

SYSMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_SYS_DATA_DH_EXOU

Column Name

Data Type

SYSMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_SYS_DATA_D_EXOU

Column Name

Data Type

SYSMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_SYS_DATA_MDCH_EXOU

Column Name

Data Type

SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
SLOPENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER
SYSMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER

Back to top ↑

PV_SYS_DATA_MONTH

Column Name

Data Type

COUNTERRORNUMBER
COUNTVALUENUMBER
SYSMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
SLOPENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER

Back to top ↑

PV_SYS_DATA_ROLL

Column Name

Data Type

SYSMETRICIDNUMBER
ROLLPERIODNUMBER
TSDATE
UPDATETSDATE
DURATIONNUMBER
COUNTNUMBER
AVGNUMBER
STDDEVNUMBER
MINNUMBER
MAXNUMBER
SLOPENUMBER
INTERCEPTNUMBER
PCTILE50NUMBER
PCTILE05NUMBER
PCTILE95NUMBER
PCTILE10NUMBER
PCTILE90NUMBER
PCTILE25NUMBER
PCTILE75NUMBER

Back to top ↑

PV_SYS_INDICATOR

Column Name

Data Type

Description
SYSIDNUMBER 
SYSMETRICIDNUMBER 
NAMEVARCHAR2(250 CHAR) 
DESCRIPTIONVARCHAR2(4000 CHAR) 
SYSTYPEIDNUMBER 
SYSTYPEVARCHAR2(50 CHAR) 
METRICVARCHAR2(50 CHAR) 
METRICNAMEVARCHAR2(250 CHAR) 
SUBMETRICNAMEVARCHAR2(512 CHAR) 
LOCATIONIDNUMBER 
LOCATIONNAMEVARCHAR2(250 CHAR) 
VALTYPEIDNUMBER 
VALTYPEVARCHAR2(50 CHAR)See PV_CAT_VAL_TYPE.
LASTVALUEVARCHAR2(4000) 

Back to top ↑

PV_SYS_IND_DATA

Column Name

Data Type

Description
SYSIDNUMBER 
SYSMETRICIDNUMBER 
NAMEVARCHAR2(250 CHAR) 
DESCRIPTIONVARCHAR2(4000 CHAR) 
SYSTYPEIDNUMBER 
SYSTYPEVARCHAR2(50 CHAR) 
METRICVARCHAR2(50 CHAR) 
METRICNAMEVARCHAR2(250 CHAR) 
SUBMETRICNAMEVARCHAR2(512 CHAR) 
LOCATIONIDNUMBER 
LOCATIONNAMEVARCHAR2(250 CHAR) 
VALTYPEIDNUMBERSee PV_CAT_VAL_TYPE.
VALTYPEVARCHAR2(50 CHAR) 
LASTVALUEVARCHAR2(4000) 

Back to top ↑

PV_SYS_TAG

Column Name

Data Type

SYSIDNUMBER
NAMEVARCHAR2(250 CHAR)
SYSTYPEIDNUMBER
SYSTYPEVARCHAR2(50 CHAR)
TAGIDNUMBER
TAGVARCHAR2(4000 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
INSERTTSDATE
UPDATETSDATE
TAGTYPEIDNUMBER
TAGTYPENAMEVARCHAR2(50 CHAR)
TAGTYPECOLORVARCHAR2(50 CHAR)

Back to top ↑

Category-related views

PV_CAT_APPL_TYPE

Column Name

Data Type

APPLTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
ENTTYPENMVARCHAR2(50 CHAR)
NAMEENVARCHAR2(50 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

Back to top ↑

PV_CAT_AUDIT_ACTION

Column Name

Data Type

AUDITACTIONIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
AUDITGROUPIDNUMBER
GROUPNAMEVARCHAR2(50 CHAR)

Back to top ↑

PV_CAT_BDRV_TYPE

Column Name

Data Type

BDRVTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
ENTTYPENMVARCHAR2(50 CHAR)
NAMEENVARCHAR2(50 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

Back to top ↑

PV_CAT_EVENT_TYPE

Column Name

Data Type

EVENTTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)

Back to top ↑

PV_CAT_PARENTSHIP_TYPE

Column Name

Data Type

PARENTSHIPTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
NODENAMEVARCHAR2(250 CHAR)
DIRECTIONNUMBER
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

Back to top ↑

PV_CAT_RM_RECOMM_TYPE

Column Name

Data Type

RMALERTTYPEIDNUMBER
NAMEVARCHAR2(250 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

Back to top ↑

PV_CAT_SYS_TYPE

Column Name

Data Type

DESCRIPTIONVARCHAR2(250 CHAR)
ENTTYPENMVARCHAR2(50 CHAR)
NAMEENVARCHAR2(50 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)
SYSTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)

Back to top ↑

PV_CAT_VAL_TYPE

Column Name

Data Type

Description
VALTYPEIDNUMBER

Number that indicates the type of value of a metric. For example, an absolute value, a percentage, or a frequency.

VALTYPEID=5 is used to identify configuration metrics.

NAMEVARCHAR2(50 CHAR) 
DESCRIPTIONVARCHAR2(250 CHAR) 
DEFAULTPLOTCOLVARCHAR2(50 CHAR)Contains the default statistic that is used when a metric is selected with the corresponding VALTYPE in an analysis.

Back to top ↑

 

 

Business Driver related views

PV_BUSINESS_DRIVER

This view contains information on business drivers.

Column Name

Data Type

Description

Key Column

BDRVID

NUMBER

Business driver ID

PK

NAME

VARCHAR2 (50 Bytes)

Business driver name

 

DESCRIPTION

VARCHAR2 (250 Bytes)

Business driver description

 

BDRVTYPEID

NUMBER

Business driver type ID

 

BDRVTYPE

VARCHAR2 (50 Bytes)

Type of the business driver (Generic, ...)

 

Back to top ↑

PV_BDRV_METRIC

This view contains information on business driver metrics.

Column Name

Data Type

Description

Key Column

BDRVID

NUMBER

Business driver ID

AK1. FK BDRVID in PV_BUSINESS_DRIVER

BDRVMETRICID

NUMBER

Business driver metric ID

PK

NAME

VARCHAR2 (50 Bytes)

Business driver name

 

DESCRIPTION

VARCHAR2 (250 Bytes)

Business driver metric description

 

BDRVTYPEID

NUMBER

Business driver type ID

 

BDRVTYPE

VARCHAR2 (50 Bytes)

Type of the business driver (Generic, ...)

 

METRIC

VARCHAR2 (50 Bytes)

Metric

 

METRICNAME

VARCHAR2 (50 Bytes)

Metric full name

 

SUBMETRICNAME

VARCHAR2 (512 Bytes)

Metric sub element name

AK1

LOCATIONID

NUMBER

Location ID

 

LOCATIONNAME

VARCHAR2 (50 Bytes)

Location name

 

VALTYPEID

NUMBER

Value type ID

See PV_CAT_VAL_TYPE.

VALTYPE

VARCHAR2 (50 Bytes)

Value type (count, rate, ...)

 

Back to top ↑

PV_BDRV_CONF_VARIATION

This view reports variations of business driver configuration parameters.

Column Name

Data Type

Description

Key Column

BDRVMETRICID

NUMBER

Business driver metric ID

PK. FK for BDRVMETRICID in PV_BDRV_METRIC

SINCEDATA

DATE

Value validity start day

PK

TODATE

DATE

Value validity end day

 

VALUE

VARCHAR2 (250 Bytes)

Metric value

 

Back to top ↑

PV_BDRV_CONF_LAST

This view reports only the last value of business driver configuration parameters.

Column Name

Data Type

Description

Key Column

BDRVMETRICID

NUMBER

Business driver metric ID

PK

SINCEDATE

DATE

Value validity start day

 

TODATE

DATE

Value validity end day

 

VALUE

VARCHAR2 (4000 Bytes)

Metric value

 

INSERTTS

DATE

Timestamp of insertion of this row

 

UPDATETS

DATE

Timestamp of last update on this row

 

Back to top ↑

PV_BDRV_DATA_DETAIL

This view contains system data at its original resolution.

Column Name

Data Type

Description

Key Column

BDRVMETRICID

NUMBER

Business driver metric ID

PK

TS

DATE

Timestamp

PK

DCLASSID

NUMBER

Day class ID

 

HCLASSID

NUMBER

Hour class ID

 

DURATION

NUMBER

Interval duration [seconds]

 

AVGVALUE

NUMBER

Average samples value in the interval

 

MINVALUE

NUMBER

Maximum sample value in the interval

 

MAXVALUE

NUMBER

Minimum sample value in the interval

 

SUMVALUE

NUMBER

Sum of samples values in the interval

 

SUMQUADVALUE

NUMBER

Sum of samples square values in the interval

 

COUNTGOOD

NUMBER

Number of samples in the interval with good value

 

COUNTWARN

NUMBER

Number of samples in the interval with warning value

 

COUNTPOOR

NUMBER

Number of samples in the interval with poor value

 

COUNTERROR

NUMBER

Number of erroneous samples in the interval

 

COUNTVALUE

NUMBER

Number of samples in the interval

 

WEIGHT

NUMBER

Weight related to resource value

 

WAVGVALUE

NUMBER

Weighted average value

 

The recommended aggregation to preserve data semantics is:

SUM(duration) AS duration,
DECODE(SUM(duration),0,0,SUM(avgvalue*duration)/SUM(duration)) AS avgvalue,
MIN(minvalue) AS minvalue,
MAX(maxvalue) AS maxvalue,
SUM(sumvalue) AS sumvalue,
SUM(sumquadvalue) AS sumquadvalue,
SUM(countgood) AS countgood,
SUM(countwarn) AS countwarn,
SUM(countpoor) AS countpoor,
SUM(counterror) AS counterror,
SUM(countvalue) AS countvalue,
SUM(weight) AS weight,
DECODE(SUM(weight),0,0,SUM(wavgvalue*weight)/SUM(weight)) AS wavgvalue,

In order to compute the variance of data samples, you can apply the following statement to the result of a time aggregation query:

decode(countvalue,1,0,(sumquadvalue/(countvalue-1)-power(avgvalue,2)*countvalue/(countvalue-1))

Back to top ↑

PV_BDRV_DATA_DH

This view contains system data at hourly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.

PV_BDRV_DATA_D

This view contains system data at daily resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.

PV_BDRV_DATA_MDCH

This view contains system data at monthly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.

Back to top ↑

PV_BDRV_DATA_MDCH_EXOU

Column Name

Data Type

BDRVMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
SLOPENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_BDRV_DATA_CUST_STAT

Column Name

Data Type

Description

NAME

VARCHAR2 (50 Bytes)

 

DESCRIPTION

VARCHAR2 (250 Bytes)

 

VALTYPEID

NUMBER

See PV_CAT_VAL_TYPE.

OWNERSHIP

NUMBER

 

BDRVOBJID

NUMBER

 

STATID

NUMBER

 

TS

DATE

Timestamp

VALUE

NUMBER)

 

COUNTSAMPLE

NUMBER

 

STATPRODID

NUMBER

 

STRINGVALUE

VARCHAR2 (250 Bytes)

 

Back to top ↑

PV_BDRV_DATA_DETAIL_EXOU

Column Name

Data Type

BDRVMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_BDRV_DATA_DH_EXOU

Column Name

Data Type

BDRVMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_BDRV_DATA_D_EXOU

Column Name

Data Type

BDRVMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_BDRV_DATA_MDCH_EXOU

Column Name

Data Type

BDRVMETRICIDNUMBER
TSDATE
TZOFFSETNUMBER
PCLASSIDNUMBER
DCLASSIDNUMBER
HCLASSIDNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTVALUENUMBER

Back to top ↑

PV_BDRV_DATA_RAW

Column Name

Data Type

BDRVMETRICIDNUMBER
TSTIMESTAMP(6)
TZOFFSETNUMBER
DURATIONNUMBER
AVGVALUENUMBER
MINVALUENUMBER
MAXVALUENUMBER
SUMVALUENUMBER
SUMQUADVALUENUMBER
CUMSUMVALUENUMBER
WEIGHTNUMBER
WAVGVALUENUMBER
COUNTVALUENUMBER
COUNTGOODNUMBER
COUNTWARNNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER
COUNTPOORNUMBER
COUNTERRORNUMBER

Back to top ↑

PV_BDRV_DATA_ROLL

Column Name

Data Type

BDRVMETRICIDNUMBER
ROLLPERIODNUMBER
TSDATE
UPDATETSDATE
DURATIONNUMBER
COUNTNUMBER
AVGNUMBER
STDDEVNUMBER
MINNUMBER
MAXNUMBER
SLOPENUMBER
INTERCEPTNUMBER
PCTILE50NUMBER
PCTILE05NUMBER
PCTILE95NUMBER
PCTILE10NUMBER
PCTILE90NUMBER
PCTILE25NUMBER
PCTILE75NUMBER

Back to top ↑

PV_BDRV_EVENT

Column Name

Data Type

TSDATE
EVENTTYPEIDNUMBER
EVENTTYPENAMEVARCHAR2(50 CHAR)
EVENTSUBTYPEIDNUMBER
EVENTSUBTYPENAMEVARCHAR2(50 CHAR)
EVENTIDNUMBER
EVENTTSDATE
INTERVENTTSDATE
RESOLUTIONTSDATE
EVENTNAMEVARCHAR2(250 CHAR)
EVENTDESCVARCHAR2(4000 CHAR)
NOTEVARCHAR2(4000 CHAR)
COLORVARCHAR2(50 CHAR)
PERIODNUMBER
PERIODSINCEDATEDATE
PERIODTODATEDATE
SEVERITYVARCHAR2(50 CHAR)
STATUSVARCHAR2(50 CHAR)
SERVICEUNAVAILABILITYNUMBER
PENDINGTIMEMILLISNUMBER
INTERVENTTIMEMILLISNUMBER
RESOLUTIONTIMEMILLISNUMBER
SOURCECLASSVARCHAR2(512 CHAR)
SRCEVENTIDVARCHAR2(50 CHAR)
COUNTOCCURRENCENUMBER
BDRVIDNUMBER
BDRVNAMEVARCHAR2(250 CHAR)
BDRVDESCVARCHAR2(4000 CHAR)
BDRVTYPEIDNUMBER
BDRVTYPEVARCHAR2(50 CHAR)

Back to top ↑

PV_BDRV_METRIC_EVENT

Column Name

Data Type

Description
TSDATE 
EVENTTYPEIDNUMBER 
EVENTTYPENAMEVARCHAR2(50 CHAR) 
EVENTSUBTYPEIDNUMBER 
EVENTSUBTYPENAMEVARCHAR2(50 CHAR) 
EVENTIDNUMBER 
EVENTTSDATE 
INTERVENTTSDATE 
RESOLUTIONTSDATE 
EVENTNAMEVARCHAR2(250 CHAR) 
EVENTDESCVARCHAR2(4000 CHAR) 
NOTEVARCHAR2(4000 CHAR) 
COLORVARCHAR2(50 CHAR) 
PERIODNUMBER 
PERIODSINCEDATEDATE 
PERIODTODATEDATE 
SEVERITYVARCHAR2(50 CHAR) 
STATUSVARCHAR2(50 CHAR) 
SERVICEUNAVAILABILITYNUMBER 
PENDINGTIMEMILLISNUMBER 
INTERVENTTIMEMILLISNUMBER 
RESOLUTIONTIMEMILLISNUMBER 
SOURCECLASSVARCHAR2(512 CHAR) 
SRCEVENTIDVARCHAR2(50 CHAR) 
COUNTOCCURRENCENUMBER 
BDRVIDNUMBER 
BDRVMETRICIDNUMBER 
BDRVNAMEVARCHAR2(250 CHAR) 
BDRVDESCVARCHAR2(4000 CHAR) 
BDRVTYPEIDNUMBER 
BDRVTYPEVARCHAR2(50 CHAR) 
METRICVARCHAR2(50 CHAR) 
METRICNAMEVARCHAR2(250 CHAR) 
SUBMETRICNAMEVARCHAR2(512 CHAR) 
LOCATIONIDNUMBER 
LOCATIONNAMEVARCHAR2(250 CHAR) 
VALTYPEIDNUMBERSee PV_CAT_VAL_TYPE.
VALTYPEVARCHAR2(50 CHAR) 

Back to top ↑

Class ID views

PV_H_CLASS

This view provides names and descriptions for hour class IDs.

Column Name

Data Type

Description

HCLASSID

NUMBER

Hour class ID

NAME

VARCHAR2 (50 Bytes)

Hour class NAME

DESCRIPTION

VARCHAR2 (250 Bytes)

Hour class description

Back to top ↑

PV_D_CLASS

This view provides names and descriptions for day class IDs.

Column Name

Data Type

Description

DCLASSID

NUMBER

Day class ID

NAME

VARCHAR2 (50 Bytes)

Day class NAME

DESCRIPTION

VARCHAR2 (250 Bytes)

Day class description

Back to top ↑

Chargeback related views

PV_CB_COST_OBJECT

This view contains information on a cost object.

Column Name

Data Type

Description

COSTOBJID

NUMBER

Cost object ID

NAME

VARCHAR2 (50 Bytes)

Cost object name

DESCRIPTION

VARCHAR2 (250 Bytes)

Cost object description

COSTOBJTYPEID

NUMBER

Cost object type ID

COSTOBJTYPE

VARCHAR2 (50 Bytes)

Type of the cost object
(Basic Cost Object, Composite Cost Object)

COSTOBJKEY

NUMBER

Cost object key

Back to top ↑

PV_CB_COST_OBJECT_METADATA

Column Name

Data Type

COSTOBJIDNUMBER
COSTOBJKEYVARCHAR2(250 CHAR)
COSTOBJSUBKEYVARCHAR2(250 CHAR)
NAMEVARCHAR2(250 CHAR)
VALUEVARCHAR2(4000 CHAR)

Back to top ↑

PV_CB_COST_OBJECT_SUBKEY

This view contains information on subkeys of a basic cost object.

Column Name

Data Type

Description

References

COSTOBJID

NUMBER

Cost object ID

PV_CB_COST_OBJECT.COSTOBJID

COSTOBJKEY

VARCHAR2 (50 Bytes)

Cost object key

PV_CB_COST_OBJECT.COSTOBJKEY

COSTOBJSUBKEY

VARCHAR2 (50 Bytes)

Cost object subkey

 

PROPNAME

VARCHAR2 (250 Bytes)

Name of the property (mode, consunit, label)

 

PROPVALUE

VARCHAR2 (250 Bytes)

Value of the property

 

Back to top ↑

PV_CB_CO_ALLOC

This view contains information on an allocation between a composite cost object and a cost object.

Column Name

Data Type

Description

References

COSTOBJID

NUMBER

Cost object ID

PV_CB_COST_OBJECT.COSTOBJID

COSTOBJNAME

VARCHAR2 (50 Bytes)

Cost object name

 

COSTOBJKEY

VARCHAR2 (50 Bytes)

Cost object key

PV_CB_COST_OBJECT.COSTOBJKEY

COSTOBJIDALLOC

NUMBER

Cost object ID allocated

PV_CB_COST_OBJECT.COSTOBJID

COSTOBJNAMEALLOC

VARCHAR2 (50 Bytes)

Cost object name allocated

 

COSTOBJKEYALLOC

NUMBER

Cost object key allocated

PV_CB_COST_OBJECT.COSTOBJKEY

ALLOCATION

NUMBER

Percentage of allocation

 

SINCEDATE

DATE

Allocation validity start day

 

TODATE

DATE

Allocation validity end day

 

Back to top ↑

PV_CB_TARGET

This view contains information on a target

Column Name

Data Type

Description

TARGETID

NUMBER

Target ID

NAME

VARCHAR2 (50 Bytes)

Target name

DESCRIPTION

VARCHAR2 (250 Bytes)

Target description

Back to top ↑

PV_CB_MODEL

This view contains information on a chargeback model

Column Name

Data Type

Description

MODELID

NUMBER

Model ID

NAME

VARCHAR2 (50 Bytes)

Model name

DESCRIPTION

VARCHAR2 (250 Bytes)

Model description

TARGETIDPARENT

NUMBER

Target root ID

CURRENCY

VARCHAR2 (50 Bytes)

Currency

Back to top ↑

PV_CB_MODEL_TARGET

Column Name

Data Type

ACBMDELIDNUMBER
ACBTARGETIDNUMBER

Back to top ↑

PV_CB_TARGET_PARENTSHIP

This view contains information on a target hierarchy.

Column Name

Data Type

Description

References

MODELID

NUMBER

Model ID

PV_CB_MODEL.MODELID

TARGETIDPARENT

NUMBER

Target parent ID

PV_CB_TARGET.TARGETID

TARGETIDCHILD

NUMBER

Target child ID

PV_CB_TARGET.TARGETID

Back to top ↑

PV_CB_TARGET_METADATA

Column Name

Data Type

TARGETIDNUMBER
NAMEVARCHAR2(250 CHAR)
VALUEVARCHAR2(4000 CHAR)

Back to top ↑

PV_CB_ALLOCATION

This view contains information on an allocation between a target and a cost object.

Column Name

Data Type

Description

References

MODELID

NUMBER

Model ID

PV_CB_MODEL.MODELID

TARGETID

NUMBER

Target ID

PV_CB_TARGET.TARGETID

TARGETNAME

VARCHAR2 (50 Bytes)

Target name

 

COSTOBJID

NUMBER

Cost object ID

PV_CB_COST_OBJECT.COSTOBJID

COSTOBJNAME

VARCHAR2 (50 Bytes)

Cost object name

 

COSTOBJKEY

VARCHAR2 (50 Bytes)

Cost object key

PV_CB_COST_OBJECT.COSTOBJKEY

ALLOCATION

NUMBER

Percentage of allocation

 

SINCEDATE

DATE

Allocation validity start day

 

TODATE

DATE

Allocation validity end day

 

Back to top ↑

PV_CB_ALLOCATION_METADATA

Column Name

Data Type

ALLOCIDNUMBER
NAMEVARCHAR2(250 CHAR)
VALUEVARCHAR2(4000 CHAR)

Back to top ↑

PV_CB_TARGET_METRIC

This view contains information on target metrics.

Column Name

Data Type

Description

References

TARGETID

NUMBER

Target ID

PV_CB_TARGET.TARGETID

TARGETNAME

VARCHAR2 (50 Bytes)

Target name

 

TARGETMETRICID

NUMBER

Target metric ID

 

METRIC

VARCHAR2 (50 Bytes)

Metric

 

METRICNAME

VARCHAR2 (50 Bytes)

Metric full name

 

COCOSTOBJKEY4

VARCHAR2 (50 Bytes)

Composite cost object key level 4

PV_CB_COST_OBJECT.COSTOBJKEY

COCOSTOBJKEY3

VARCHAR2 (50 Bytes)

Composite cost object key level 3

PV_CB_COST_OBJECT.COSTOBJKEY

COCOSTOBJKEY2

VARCHAR2 (50 Bytes)

Composite cost object key level 2

PV_CB_COST_OBJECT.COSTOBJKEY

COCOSTOBJKEY1

VARCHAR2 (50 Bytes)

Composite cost object key level 1

PV_CB_COST_OBJECT.COSTOBJKEY

COSTOBJKEY

VARCHAR2 (50 Bytes)

Basic Cost object key

PV_CB_COST_OBJECT.COSTOBJKEY

COSTOBJSUBKEY

VARCHAR2 (50 Bytes)

Cost object subkey

PV_CB_COST_OBJECT_SUBKEY.COSTOBJSUBKEY

METADATA

VARCHAR2 (50 Bytes)

Metadata

 

Note

There can be a maximum of 4 nested composite cost object levels. Levels are labeled as shown in the following figure:

Cost object nesting

Back to top ↑

PV_CB_TARGET_DATA_DAY

This view contains target data.

Column Name

Data Type

Description

References

TARGETMETRICID

NUMBER

Target metric

ID PV_CB_TARGET.TARGETID

TS

DATE

Timestamp

 

DURATION

NUMBER

Duration of the period in which samples were collected

 

VALUE

NUMBER

Sample value

 

Back to top ↑

PV_CB_COST_RATE

This view contains information on a cost rate.

Column Name

Data Type

Description

References

MODELID

NUMBER

Model ID

PV_CB_MODEL.MODELID

COSTOBJID

NUMBER

Cost object

ID PV_CB_COST_OBJECT.COSTOBJID

COSTOBJNAME

VARCHAR2 (50 Bytes)

Cost object name

 

COSTOBJKEY

VARCHAR2 (50 Bytes)

Cost object key

PV_CB_COST_OBJECT.COSTOBJKEY

COSTOBJSUBKEY

VARCHAR2 (50 Bytes)

Cost object subkey

PV_CB_COST_OBJECT_SUBKEY.COSTOBJSUBKEY

METADATA

VARCHAR2 (250 Bytes)

Metadata value

 

COSTRATENAME

VARCHAR2 (50 Bytes)

Cost rate name

 

COSTRATE

NUMBER

Cost rate value

 

CONSUNIT

VARCHAR2 (50 Bytes)

Consumption unit

 

COSTUNIT

VARCHAR2 (50 Bytes)

Cost unit

 

SINCEDATE

DATE

Cost rate validity start day

 

TODATE

DATE

Cost rate validity end day

 

Back to top ↑

PV_CB_COST_RATE_METADATA

Column Name

Data Type

COSTRATEIDNUMBER
NAMEVARCHAR2(250 CHAR)
VALUEVARCHAR2(4000 CHAR)

Back to top ↑

Other

PV_ENT_PARENTSHIP_CURRENT

This view contains information on relationship between systems, business drivers and domains (hierarchy).

Column Name

Data Type

Description

Key column

STRUCTUREIDPARENT

VARCHAR2 (6 Bytes)

Structure of father node

PK. “FK” indicates whether parent is a SYS, BDRV, or APP

IDPARENT

NUMBER

ID of father node

PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

STRUCTUREIDCHILD

VARCHAR2 (6 Bytes)

Structure of child node

PK. “FK” indicates whether child is a SYS, BDRV, or APP

IDCHILD

NUMBER

ID of child node

PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

SINCEDATE

DATE

Value validity start day

 

TODATE

DATE

Value validity end day

 

PARENTSHIPTYPEID

NUMBER

Parentship type ID

 

PARENTSHIPTYPE

VARCHAR2 (50 Bytes)

Parentship type name

 

Back to top ↑

PV_ENT_PARENTSHIP_HIST

This view contains historical information on relationship between systems, business drivers and domains (hierarchy).

Column Name

Data Type

Description

Key column

STRUCTUREIDPARENT

VARCHAR2 (6 Bytes)

Structure of father node

PK. “FK” indicates whether parent is a SYS, BDRV, or APP

IDPARENT

NUMBER

ID of father node

PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

STRUCTUREIDCHILD

VARCHAR2 (6 Bytes)

Structure of child node

PK. “FK” indicates whether child is a SYS, BDRV, or APP

IDCHILD

NUMBER

ID of child node

PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

SINCEDATE

DATE

Value validity start day

PK

TODATE

DATE

Value validity end day

 

PARENTSHIPTYPEID

NUMBER

Parentship type ID

 

PARENTSHIPTYPE

VARCHAR2 (50 Bytes)

Parentship type name

 

HIERRULEID

NUMBER

Hierarchy rule id

 

HIERRULE

VARCHAR2 (50 Bytes)

Hierarchy rule name

 

Back to top ↑

PV_ENT_LOOKUP

Column Name

Data Type

SRCIDNUMBER
SRCIDSHARELOOKUPNUMBER
LOOKUPFIELDVARCHAR
LOOKUPVALUEVARCHAR
STRUCTUREIDVARCHAR
IDNUMBER
INSERTTSDATE
ACTIVITYDATEDATE
DATASOURCENAMEVARCHAR
ETLMODIDNUMBER
ETLMODULEVARCHAR
OWNERSHIPNUMBER
COMPONENTIDNUMBER
COMPONENTNAMEVARCHAR

Back to top ↑

PV_TASK

Column Name

Data Type

TASKIDNUMBER
NAMEVARCHAR2(250 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
ENABLEDNUMBER(1)
TASKTYPEIDNUMBER
TASKTYPEVARCHAR2(50 CHAR)
PERIODNUMBER
SCHEDULERIDNUMBER
SRCIDNUMBER
COMPONENTIDNUMBER
COMPONENT_NAMEVARCHAR2(250 CHAR)
COMPTYPEIDNUMBER
COMPTYPEVARCHAR2(50 CHAR)
STATUSVARCHAR2(250 CHAR)
EXITCODEVARCHAR2(25 CHAR)
LASTEXECTSDATE
NEXTEXECTSDATE
TASKIDPARENTNUMBER

Back to top ↑

PV_TASK_RUN

Column Name

Data Type

TASKRUNIDNUMBER
TASKIDNUMBER
NAMEVARCHAR2(250 CHAR)
TASKIDPARENTNUMBER
EXECTSDATE
EXITCODEVARCHAR2(25 CHAR)
STATUSVARCHAR2(250 CHAR)
DURATIONNUMBER
EXTRACTDURATIONNUMBER
LOADDURATIONNUMBER
CREATEDENTITIESNUMBER
CONFDATALOADEDNUMBER
TSDATALOADEDNUMBER
OBJRELDATALOADEDNUMBER
LOADEDENTITIESNUMBER
TASKEXECREQIDNUMBER
EXECPCTNUMBER
ACCOUNTIDNUMBER
ACCOUNTVARCHAR2(50 CHAR)

Back to top ↑

PV_APPL_CONF_VARIATION

Column Name

Data Type

APPMETRICIDNUMBER
SINCEDATEDATE
TODATEDATE
VALUEVARCHAR2(4000 CHAR)
INSERTTSDATE
UPDATETSDATE

Back to top ↑

PV_APPL_CONF_LAST

Column Name

Data Type

APPMETRICIDNUMBER
SINCEDATEDATE
TODATEDATE
VALUEVARCHAR2(4000 CHAR)
INSERTTSDATE
UPDATETSDATE

Back to top ↑

PV_ANALYSIS_STAT_PROD

Column Name

Data Type

STATPRODIDNUMBER
STATPRODKEYVARCHAR2(250 CHAR)
PLOTIDNUMBER
NAMEVARCHAR2(250 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
TEMPLIDNUMBER
TEMPLNAMEVARCHAR2(250 CHAR)
TYPEIDNUMBER
TYPENAMEVARCHAR2(50 CHAR)
TIMEFILTERIDVARCHAR2(4000 CHAR)
TIMEFILTERNAMEVARCHAR2(250 CHAR)
CUSTOMTIMERANGEVARCHAR2(4000 CHAR)

Back to top ↑

PV_AUDIT_MESSAGE

Column NameData Type
AUDITGROUPIDNUMBER
AUDITGROUPNAMEVARCHAR2(50 CHAR)
AUDITMSGIDNUMBER
TSDATE
AUDITACTIONIDNUMBER
ACTIONNAMEVARCHAR2(50 CHAR)
ACTIONDESCRVARCHAR2(250 CHAR)
ACCOUNTIDNUMBER
ACCOUNTNAMEVARCHAR2(50 CHAR)
ACCOUNTFULLNAMEVARCHAR2(50 CHAR)
COMPONENTVARCHAR2(250 CHAR)
COMPONENTTYPEVARCHAR2(50 CHAR)
SUBCOMPONENTVARCHAR2(249)
IDSTRVARCHAR2(250 CHAR)
MESSAGEVARCHAR2(4000 CHAR)
ELAPSEDNUMBER
HOSTIDNUMBER
HOSTNAMEVARCHAR2(250 CHAR)

Back to top ↑

Event-related views

PV_EVENT

This view contains information on events.

Column Name

Data Type

Description

TS

DATE

Timestamp

EVENTTYPEID

NUMBER

Event type ID

EVENTTYPENAME

VARCHAR2 (50 Bytes)

Event type name

EVENTSUBTYPEID

NUMBER

Event subtype ID

EVENTSUBTYPENAME

VARCHAR2 (50 Bytes)

Event subtype name

EVENTID

NUMBER

Event ID

EVENTTS

DATE

Event date

INTERVENTTS

DATE

 

RESOLUTIONTS

DATE

 

EVENTNAME

VARCHAR2 (250 Bytes)

 

EVENTDESC

VARCHAR2 (4000 Bytes)

 

NOTE

VARCHAR2 (4000 Bytes)

 

COLOR

VARCHAR2 (50 Bytes)

 

PERIOD

NUMBER

 

PERIODSINCEDATE

DATE

 

PERIODTODATE

DATE)

 

SEVERITY

VARCHAR2 (50 Bytes)

 

STATUS

VARCHAR2 (50 Bytes)

 

SERVICEUNAVAILABILITY

NUMBER

 

PENDINGTIMEMILLIS

NUMBER

 

INTERVENTTIMEMILLIS

NUMBER

 

RESOLUTIONTIMEMILLIS

NUMBER

 

SOURCECLASS

VARCHAR2 (512 Bytess)

 

SRCEVENTID

VARCHAR2 (50 Bytess)

 

COUNTOCCURRENCE

NUMBER

 

Back to top ↑

PV_EVENT_OBJECT

This view contains information on the object related to an event.

Column Name

Data Type

EVENTID

NUMBER

OBJNAME

VARCHAR2 (50 Bytes)

REFERREDID

NUMBER

Back to top ↑

Domain-related views

PV_APPLICATION

This view contains information on domains.

Column Name

Data Type

Description

Key column

APPID

NUMBER

Domain ID

PK

APPLNAME

VARCHAR2 (50 Bytes)

Domain name

 

APPLDESCRIPTION

VARCHAR2 (250 Bytes)

Domain description

 

GROUPID

NUMBER

Domain group ID

FK in PV_APPLICATION

GROUPNAME

VARCHAR2 (50 Bytes)

Domain group name

 

GROUPDESCRIPTION

VARCHAR2 (250 Bytes)

Domain group description

 

Back to top ↑

PV_APPL_BDRV

Use this view to join PV_APPLICATION and PV_BDRV_METRIC, in order to retrieve metrics of all the business drivers owned by a certain domain.

Column Name

Data Type

Description

BDRVID

NUMBER

Business driver ID

APPID

NUMBER

Domain ID

Back to top ↑

PV_APPL_EVENT

Use this view to join PV_APPLICATION and PV_EVENT, in order to retrieve events as per domains.

Column Name

Data Type

Description

TS

DATE

Timestamp

EVENTTYPEID

NUMBER

 

EVENTTYPENAME

VARCHAR2 (50 Bytes)

 

EVENTSUBTYPEID

NUMBER

 

EVENTSUBTYPENAME

VARCHAR2 (50 Bytes)

 

EVENTID

NUMBER

 

EVENTTS

DATE

 

INTERVENTTS

DATE

 

RESOLUTIONTS

DATE

 

EVENTNAME

VARCHAR2

 

EVENTDESC

VARCHAR2

 

NOTE

VARCHAR2 (4000 Bytes)

 

COLOR

VARCHAR2 (50 Bytes)

 

PERIOD

NUMBER

 

PERIODSINCEDATE

DATE

 

PERIODTODATE

DATE

 

SEVERITY

VARCHAR2 (50 Bytes)

 

STATUS

VARCHAR2 (50 Bytes)

 

SERVICEUNAVAILABILITY

NUMBER

 

PENDINGTIMEMILLIS

NUMBER

 

INTERVENTTIMEMILLIS

NUMBER

 

RESOLUTIONTIMEMILLIS

NUMBER

 

SOURCECLASS

VARCHAR2 (512 Bytes)

 

SRCEVENTID

VARCHAR2 (50 Bytes)

 

COUNTOCCURRENCE

NUMBER

 

APPID

NUMBER

 

APPLNAME

VARCHAR2 (250 Bytes)

 

APPLDESCRIPTION

VARCHAR2 (4000 Bytes)

 

GROUPID

NUMBER

 

GROUPNAME

VARCHAR2 (250 Bytes)

 

GROUPDESCRIPTION

VARCHAR2 (4000 Bytes)

 

Back to top ↑

PV_APPL_SYS

Use this view to join PV_APPLICATION and PV_SYS_METRIC, in order to retrieve the metrics of all the systems owned by a certain domain.

Column Name

Data Type

Description

Key column

SYSID

NUMBER

System ID

PK. FK SYSID in PV_SYSTEM

APPID

NUMBER

Domain ID

PK. FK APPID in PV_APPLICATION

Back to top ↑

 

PV_APPL_METRIC

Use this view to retrieve metric instances owned by a certain domain.

PV_APPL_TAG

Column NameData Type
TAGTYPENAMEVARCHAR2(50 CHAR)
TAGTYPECOLORVARCHAR2(50 CHAR)
APPIDNUMBER
NAMEVARCHAR2(250 CHAR)
APPLTYPEIDNUMBER
APPLTYPEVARCHAR2(50 CHAR)
TAGIDNUMBER
TAGVARCHAR2(4000 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
INSERTTSDATE
UPDATETSDATE
TAGTYPEIDNUMBER

Back to top ↑

PV_APPL_WKLD

Column NameData Type

APPID

NUMBER
WKLDIDNUMBER

Back to top ↑

Optimizer alert views

PV_RM_ALERT_LOG

 Use the view to join PV_RM and PV_ALERT_LOG, in order to retrieve the metrics of all the systems owned by a certain domain.

Column NameData TypeDescription
RMALERTIDNUMBEROptimizer Alert rule ID
RMALERTNAMEVARCHAROptimizer Alert rule name
TSDATEAlert triggering date
STRUCTUREIDVARCHARStructure of alerted entity
IDNUMBERID of alerted entity
TYPEIDNUMBERAlerted entity type ID
NAMEVARCHARName of the alerted entity
STATUSIDNUMBERStatus ID of the alerted entity
RMALERTSTATUSIDNUMBERAssigned alert status ID
RMALERTSTATUSNAMEVARCHAR

Assigned alert status name

(OK,WARNING, and CRITICAL)
RMALERTREASONVARCHARAlert reason
LASTRUNTSDATELast execution date of the rule

Back to top ↑

PV_RM_RECOMM

Column NameData Type
STRUCTUREIDVARCHAR2(6 CHAR)
ENTIDNUMBER
RMALERTIDNUMBER
RMALERTVARCHAR2(50 CHAR)
RMALERTTYPEVARCHAR2(250 CHAR)
CATEGORYVARCHAR2(50)
SEVERITYVARCHAR2(50 CHAR)
SEV_INDEXNUMBER
RMALERTTEMPLIDNUMBER
RMALERTTEMPLVARCHAR2(250 CHAR)
PRIORITYNUMBER
TSDATE
SMALLDESCRIPTIONVARCHAR2(4000 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
RECOMMENDATIONVARCHAR2(4000 CHAR)
RESOURCESVARCHAR2(250 CHAR)

Back to top ↑

PV_RM_RULE

Column NameData Type
RMALERTIDNUMBER
INSERTTSDATE
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
LASTRUNTSDATE
RMALERTTEMPLIDNUMBER
RMALERTTEMPLVARCHAR2(250 CHAR)

Back to top ↑

ETL-related views

PV_ETL

Column NameData Type
TASKIDNUMBER
NAMEVARCHAR2(250 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
ENABLEDNUMBER(1)
TASKTYPEIDNUMBER
TASKTYPEVARCHAR2(50 CHAR)
PERIODNUMBER
SCHEDULERIDNUMBER
SRCIDNUMBER
ETLMODIDNUMBER
COMPONENTIDNUMBER
COMPONENT_NAMEVARCHAR2(250 CHAR)
COMPTYPEIDNUMBER
COMPTYPEVARCHAR2(50 CHAR)
STATUSVARCHAR2(250 CHAR)
EXITCODEVARCHAR2(25 CHAR)
LASTEXECTSDATE
NEXTEXECTSDATE
TASKIDPARENTNUMBER
ETLMODULEVARCHAR2(250 CHAR)
ETLMODTYPEVARCHAR2(20 CHAR)
ETLMODPACKAGEVARCHAR2(250 CHAR)
ETLMODVENDORVARCHAR2(250 CHAR)

Back to top ↑

PV_ETL_RUN

Column NameData Type
TASKRUNIDNUMBER
TASKIDNUMBER
NAMEVARCHAR2(250 CHAR)
TASKIDPARENTNUMBER
EXECTSDATE
EXITCODEVARCHAR2(25 CHAR)
STATUSVARCHAR2(250 CHAR)
DURATIONNUMBER
EXTRACTDURATIONNUMBER
LOADDURATIONNUMBER
CREATEDENTITIESNUMBER
CONFDATALOADEDNUMBER
TSDATALOADEDNUMBER
OBJRELDATALOADEDNUMBER
LOADEDENTITIESNUMBER
TASKEXECREQIDNUMBER
EXECPCTNUMBER
ACCOUNTIDNUMBER
ACCOUNTVARCHAR2(50 CHAR)

Back to top ↑

 

Forecast Model-related views

PV_FORECAST_MODEL_DETAILS

Column NameData Type
TCIDNUMBER
TIMEFILTERIDVARCHAR2(4000 CHAR)
TIMEFILTERNAMEVARCHAR2(250 CHAR)
TIMEBACKVARCHAR2(4000 CHAR)
TIMEFWDVARCHAR2(4000 CHAR)
ALGORITHMTYPEVARCHAR2(4000 CHAR)
ALGORITHMNAMEVARCHAR2(4000 CHAR)
MANUALTHRESHOLDVARCHAR2(4000 CHAR)

Back to top ↑

Model-related views

PV_MODEL_STAT_PROD

Column NameData Type
STATUSIDNUMBER
STATUSVARCHAR2(50 CHAR)
STATPRODKEYVARCHAR2(250 CHAR)
TCIDNUMBER
MODELIDNUMBER
NAMEVARCHAR2(503 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
MODELNAMEVARCHAR2(250 CHAR)
MODELDESCRIPTIONVARCHAR2(4000 CHAR)
MODELTYPEIDNUMBER
MODELTYPENAMEVARCHAR2(50)
TCNAMEVARCHAR2(250 CHAR)
TCDESCRIPTIONVARCHAR2(4000 CHAR)
STATPRODIDNUMBER

Back to top ↑

Object Map-related views

PV_OBJ_MAP_DATA_CUST_STAT

Column NameData TypeDescription
SERIESIDPRIVARCHAR2(512 CHAR) 
STRUCTUREIDSECVARCHAR2(6 CHAR) 
SERIESIDSECVARCHAR2(512 CHAR) 
STATIDNUMBER 
TSDATE 
VALUENUMBER 
COUNTSAMPLENUMBER 
STRINGVALUEVARCHAR2(250 CHAR) 
STATPRODIDNUMBER 
NAMEVARCHAR2(50 CHAR) 
DESCRIPTIONVARCHAR2(250 CHAR) 
VALTYPEIDNUMBERSee PV_CAT_VAL_TYPE.
OWNERSHIPNUMBER 
STRUCTUREIDPRIVARCHAR2(6 CHAR) 

Back to top ↑

Reservation-related views

PV_RESERVATION

This view contains the list of reservations. Resource requirements are the sum of requested capacity of all "reservation components" for a certain reservation.

Column Name

Data Type

Key column

RSVID

NUMBERX

NAME

VARCHAR 
EXTERNALIDNUMBER 

CONTAINERPOOLIDS

VARCHAR 

CONTAINERPOOLNAMES

VARCHAR 

DESCRIPTION

VARCHAR 

INSERTTS

DATE 

UPDATETS

DATE 

PRIORITY

NUMBER 

PRIORITYSTRING

VARCHAR 
START_DATEDATE 
END_DATEDATE 

STATUSID

NUMBERMapped to accepted, pending, committed, rejected, expired

STATUS

VARCHAR

 

RSVALERTSTATUS

VARCHAR

 

RSVALERTSTATUSIDNUMBER 

RSVALERTSTATUS_DESCRIPTION

VARCHAR

 

OWNER

VARCHAR

 

CPUMHZ

NUMBER

 

MEMORY

NUMBER

 

DISKNUMBER 

VCPUNUM

NUMBER

 

CPUCORES

NUMBER

 

CPUMHZCAPACITYNUMBER 
MEMECAPACITYNUMBER 
DSKCAPACITYNUMBER 
LCPUCAPACITYNUMBER 
CPUENTCCAPACITYNUMBER 

ALERTEDCONTAINERS

VARCHAR

 

TENANTVARCHAR 

Back to top ↑

PV_CAPACITY_POOL

This view contains the list of capacity pools.

Column Name

Data Type

SYSIDNUMBER

NAME

VARCHAR
DESCRIPTIONVARCHAR
SYSTYPEIDNUMBER
SYSTYPEVARCHAR
RESERVATIONAVAILABILITYVARCHAR
RSVALERTSTATUSIDNUMBER
RSVALERTSTATUSVARCHAR
RSVALERTSTATUSDESCRIPTIONVARCHAR
RSVALERTSTATTSDATE
PENDINGRSVNUMNUMBER
COMMITTEDRSVNUMNUMBER
CONTAINERSNUMNUMBER

Back to top ↑

PV_CONTAINER_POOL_RSVCONTAINER

Column Name

Data Type

CONTAINERPOOLIDNUMBER
RSVCONTAINERIDNUMBER

Back to top ↑

PV_RSV_CAPACITY_POOL

This view contains the list of capacity pools.

Column Name

Data Type

CONTAINERPOOLIDNUMBER

RSVID

NUMBER

Back to top ↑

PV_RSV_CONTAINER

This view contains the list of capacity containers.

Column Name

Data Type

Key column

SYSID

NUMBER RSV_CONTAINER.SYSID (FK)

NAME

VARCHAR

 SYS_DEF.NAME

SYSTYPEID

NUMBER

 
STATUSIDNUMBER 

RSVTYPEID

NUMBER

 

RSVALERTSTATUSID

NUMBER 

RSVALERTTS

DATE

 

CONTAINERPOOLIDS

VARCHAR

 

CONTAINERPOOLNAMES

VARCHAR

 
GMONNUMNUMBER 
VCPUONNUMNUMBER 

SPAREVM_ALLOCATION

NUMBER

 

SPAREVM_UTILIZATION

NUMBER 

SPAREVMP1_ALLOCATION

NUMBER

 

SPAREVMP1_UTILIZATION

NUMBER

 

SPAREVMP2_ALLOCATION

NUMBER 

SPAREVMP2_UTILIZATION

NUMBER 

LIMITINGRESOURCE_ALLOCATION

VARCHAR

 

LIMITINGRESOURCE_UTILIZATION

VARCHAR 

COMMITTEDRESERVATIONS

NUMBER

 

PENDINGRESERVATIONS

NUMBER

 
SPAREVM_BASISVARCHAR 

Back to top ↑

PV_RSV_ONBOARDING

Lists all On-boarding events. For each onboarding reports destination container, date of on-boarding, and total additional capacity provided.

Column Name

Data Type

Key column

RSVONBOARDINGIDNUMBERX
NAMEVARCHAR 
DESCRIPTIONVARCHAR 
INSERTTSDATE 
UPDATETSDATE 
ONBOARDING_DATEDATE 
OFFBOARDING_DATEDATE 
STATUSIDNUMBER 
STATUSVARCHAR 
NUMNUMBER 
CPU_TOTAL_MHZNUMBER 
CPU_NUMNUMBER 
TOTAL_REAL_MEMNUMBER 
DISK_SIZENUMBER 
CONTAINERIDNUMBER 
CONTAINERNAMEVARCHAR 
RSVTYPEIDNUMBER 
PROVISIONTSDATE 
RSVCONTAINERIDNUMBERRSV_CONTAINER.SYSID
RSVCONTAINERNAMEVARCHAR 
CONTAINERPOOLIDNUMBER 
CONTAINERNAMEVARCHAR 

Back to top ↑

PV_RSV_ONBOARDING_SYS

Associates, for each on-boarding event, all "templates" included into an onboarding

Column Name

Data Type

Key column

SYSIDNUMBERSYS_DEF.SYSID
NAMEVARCHAR 
DESCRIPTIONVARCHAR 
SYSTYPEIDNUMBER 
RSVONBOARDINGIDNUMBERRSV_ONBOARDING.RSVONBOARDINGID
NUMNUMBER 
CPU_TOTAL_MHZNUMBER 
CPU_NUMNUMBER 
TOTAL_REAL_MEMNUMBER 
DISK_SIZENUMBER 
OSVARCHAR 

Back to top ↑

PV_RSV_RSVITEM

Column Name

Data Type

RSVITEMIDNUMBER

RSVITEMNAME

VARCHAR
TEMPLATEIDNUMBER
SYSIDNUMBER
TEMPLATENAMEVARCHAR
SYSTYPEIDNUMBER
SYSTYPEVARCHAR
SERVICEIDNUMBER
SERVICENAMEVARCHAR
RSVIDNUMBER
CONGTAINERIDNUMBER
CONTAINERNAMEVARCHAR
CONTAINERTYPEIDNUMBER
VCPUNUMNUMBER
CPUMHZNUMBER
CPUMHZCAPACITYNUMBER
CPUCORESNUMBER
CPUENTCCAPACITYNUMBER
LCPUCAPACITYNUMBER
MEMORYNUMBER
MEMCAPACITYNUMBER
DISKNUMBER
DISKCAPACITYNUMBER
OSTYPEVARCHAR
CONTAINERPOOLIDNUMBER
CONTAINERPOOLNAMEVARCHAR
SYSIDREALNUMBER
SYSNAMEREALVARCHAR
SYSTYPEIDREALNUMBER

Back to top ↑

PV_RSV_RSVTEMPLATE

Column Name

Data Type

STRUCTUREIDNUMBER

XID

NUMBER
NAMEVARCHAR
SYSTYPEIDNUMBER
SYSTYPENUMBER
RSVIDNUMBER
NUMNUMBER
CPUMHZNUMBER
CPUCORESNUMBER
VCPUNUMNUMBER
MEMORYNUMBER
DISKNUMBER
CPUMHZCAPACITYNUMBER
MEMCAPACITYNUMBER
DISKCAPACITYNUMBER
LCPUCAPACITYNUMBER
CPUENTCCAPACITYNUMBER
OSVARCHAR

Back to top ↑

PV_RSV_SYS_TEMPLATE

Column Name

Data Type

SYSIDNUMBER

NAME

VARCHAR
SYSTYPEIDNUMBER
SYSTYPEVARCHAR
CPUMHZNUMBER
CPUCORESNUMBER
VCPUNUMNUMBER
MEMORYNUMBER
DISKNUMBER
CPUMHZCAPACITYNUMBER
MEMCAPACITYNUMBER
DSKCPACITYNUMBER
CPUENTCCAPACITYNUMBER
LCPUCAPACITYNUMBER
OSVARCHAR
USED_INTO_RESERVATIONSVARCHAR

Back to top ↑

PV_RSV_SERVICE_TEMPLATE

Column Name

Data Type

SERVICEIDNUMBER

NAME

VARCHAR
TYPEIDNUMBER
TYPEVARCHAR
CPUMHZNUMBER
CPUCORESNUMBER
VCPUNUMNUMBER
MEMORYNUMBER
DISKNUMBER
CPUMHZCAPACITYNUMBER
MEMCAPACITYNUMBER
DSKCPACITYNUMBER
CPUENTCCAPACITYNUMBER
LCPUCAPACITYNUMBER
OSVARCHAR
USED_INTO_RESERVATIONSVARCHAR

Back to top ↑

PV_RSV_COMPONENTS_CONTAINER

For each reservation, reports all "reservation components" with required resources, involved container (according to reservation status) and its alert status (if any). (join between RSV_SYS_CONTAINER and RSV_APP(SYS)_DATA and RSV_CONTAINER)

Column NameDescriptionKey column
RSVID RSV_DEF.RSVID (FK)
SYSID RSV_SYS.SYSID (FK)
APPID RSV_APP.APPID (FK)
INSTANCEID  
NAMESYS_DEF.NAME 
RSVNAMERSV_DEF.NAME 
RSVCONTAINERIDcan be null(FK) RSV_CONTAINER.SYSID
RSVCONTAINERNAMEcan be null 
VCPU_NUM  
CPU_MHZ  
CPU_ENTITLEMENT  
CPU_SPECINT  
MEMORY  
STORAGE  
RSVALERTSTATUSIDalert status of containerRSV_ALERT_STATUS.RSVALERTSTATUSID
RSVALERTTS  

Back to top ↑

Indicator-related views

PV_SYS_INDICATOR

Column NameDescription
SYSIDThe id of the system
SYSMETRICIDThe id of the metric
NAMEThe name of the indicator
DESCRIPTIONThe description of the indicator (if available)
SYSTYPEID The id of the system type
SYSTYPE The type of the system
LOCATIONIDThe id of the location
LOCATIONNAMEThe name of the location
METRICMetric
METRICNAMEThe name of the metric
SUBMETRICNAMEThe name of the submetric
VALTYPEIDSee PV_CAT_VAL_TYPE.
VALTYPE Value type
LASTVALUEThe last value of the indicator. Should be returned by the function.

Back to top ↑

Tag-related views

PV_SYS_TAG

Describes tags that are placed on TrueSight Capacity Optimization systems.

Column NameDescription
SYSIDThe id of the tagged system
NAMEThe name of the system
SYSTYPEIDThe type of the system as id
SYSTYPEThe type of the system
TAGThe value of the tag
TAGIDThe internal identifier of the tag
TAGTYPECOLORThe color of the tag type
TAGTYPEIDThe internal identifier of the tag type
TAGTYPENAMEThe type of the tag
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

Back to top ↑

PV_BDRV_TAG

Describes tags that are placed on TrueSight Capacity Optimization business driver

Column NameDescription
BDRVIDThe id of the tagged business driver
NAMEThe name of the business driver
BDRVTYPEIDThe type of the business driver as id
BDRVTYPEThe type of the business driver
TAGThe value of the tag
TAGIDThe internal identifier of the tag
TAGTYPECOLORThe color of the tag type
TAGTYPEIDThe internal identifier of the tag type
TAGTYPENAMEThe type of the tag
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

Back to top ↑

PV_APPL_TAG

Describes tags that are placed on TrueSight Capacity Optimization domain

APPIDThe id of the tagged domain
NAMEThe name of the domain
APPLTYPEIDThe type of the domain as id
APPLTYPEThe type of the domain
TAGThe value of the tag
TAGIDThe internal identifier of the tag
TAGTYPENAMEThe type of the tag
TAGTYPEIDThe internal identifier of the tag type
TAGTYPECOLORThe color of the tag type
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

Back to top ↑

PV_REP_TAG

Describes tags that are placed on TrueSight Capacity Optimization report

Column NameDescription
REPIDThe id of the tagged report
NAMEThe name of the report
REPTYPEThe type of the report
REPTYPEIDThe internal identifier of the report type
TAGThe value of the tag
TAGIDThe internal identifier of the tag
TAGTYPECOLORThe color of the tag type
TAGTYPEIDThe internal identifier of the tag type
TAGTYPENAMEThe type of the tag
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

Back to top ↑

PV_REP_RUN

Column NameDescription
REPIDThe id of the tagged report
NAMEThe name of the report
INSERTTSThe insert timestamp of the tag
RUNDATEThe date when the report was last run
URLThe URL of the report

Back to top ↑

PV_REPORT

Column NameDescription
REPIDNUMBER
INSERTTSDATE
NAMEVARCHAR2(250 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
REPTEMPLIDNUMBER
REPTEMPLVARCHAR2(250 CHAR)
REPTYPEIDNUMBER
REPTYPEVARCHAR2(50 CHAR)
ACCOUNTIDNUMBER
ACCOUNTVARCHAR2(50 CHAR)
FOLDERIDNUMBER
FOLDERVARCHAR2(250 CHAR)

Back to top ↑

Public Function Package

You can extract dynamic thresholds defined for an entity within a custom SQL data mart. To do this, use the PFUNC package. PFUNC is a public function package that stores all functions that retrieve thresholds from a custom SQL data mart.

The following table lists all the functions available in PFUNC:

Name

Description

Mandatory fields

pf_threshold_get_by_object(p_structureid, p_metricid, p_appid, p_ts)

Allow to retrieve threshold values by metric.

Parameters:
- <p_structureid>: Could be SYS, WKLD, APP
- <p_metricid>: Is the identifier of metric that can be retrieved from PV_SYS_METRIC (sysmetricid) or PV_BDRV_METRIC (bdrvmetricid) or PV_APPL_METRIC (appmetricid)
- <p_appid>: To filter threshold by a specific domain
- <p_ts>: In case threshold has a configuration metricas limit, return the metric value at that date

p_structureid, p_metricid

pf_threshold_get_by_entity(p_structureid, p_id, p_metric, p_appid, p_ts)

Allow to retrieve threshold values for a certain metric by entity

Parameters:
- <p_structureid>: could be SYS, WKLD, APP
- <p_id>: is the identifier of system from PV_SYSTEM (sysid) or PV_BUSINESS_DRIVER (bdrvid) or PV_APPLICATION (appid)
- <p_metric>: is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
- <p_appid>: to filter threshold by a specific domain
- <p_ts>: in case threshold has as limit a configuration metric, return metric value at that date

p_structureid, p_id, p_metric

pf_threshold_get_by_enttype(p_structureid, p_enttypeid, p_metric, p_appid)

Allow to retrieve threshold values for a certain metric by entity type.

Parameters:
- <p_structureid>: Could be SYS, WKLD, APP
- <p_enttypeid>: Type of entity, can be SYSTYPEID or BDRVTYPEID or APPLTYPEID depending on p_structureid. See also PV_CAT_SYS_TYPE, PV_CAT_APPL_TYPE and PV_CAT_BDRV_TYPE
- <p_metric>: Is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
- <p_appid>: To filter threshold by a specific domain

p_structureid, p_enttypeid, p_metric

pf_threshold_get_by_resource(p_metric, p_appid)

Allow to retrieve threshold values by metric

Parameters:
- <p_metric>: Is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
- <p_appid>: To filter threshold by a specific domain

p_metric

Back to top ↑

Was this page helpful? Yes No Submitting... Thank you

Comments