Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Info
The `_H` table summarizes the data per hour. The `_D` table summarizes the data per day. The `_W` table summarizes the data per week. The `_M` table summarizes the data per month. `(N <table_name>)` means normalized, the actual name can be retrieved from the `<table_name>`.

Info

The _H table summarizes the data per hour.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column Name	Column Description
`ORDI_PWII_INSTANCE_ID`	ID of the database.
`ORDI_TIMESTAMP`	Timestamp of the sampling.
`ORDI_NETWORK_ID`	Network address of this dispatcher (`N PW_ORNT_NETWORK_N`).
`ORDI_MESSAGES_SUM`	Total number of messages processed by this dispatcher.
`ORDI_BYTES_SUM`	Total size of messages processed by this dispatcher.
`ORDI_BREAKS_SUM`	Total number of breaks occurring in the connection.
`ORDI_IDLE_SUM`	Total idle time for this dispatcher, in hundredths of a second).
`ORDI_BUSY_SUM`	Total busy time for this dispatcher, in hundredths of a second.
`ORDI_MINUTES_COUNT_SUM`	Total amount of minutes summed in the row.
`ORDI_PWHG_ID`	The hour group ID that matches the sampled time.
`ORDI_RECEIVED_TIMESTAMP`	The timestamp that the row was loaded into the PW.

PW_ORFV_STAT_FILE_VIEW_H

Stores information about the file's read and write statistics.

Info
The `_H` table summarizes the data per hour. The `_D` table summarizes the data per day. The `_W` table summarizes the data per week. The `_M` table summarizes the data per month. `(N <table_name>)` means normalized, the actual name can be retrieved from the `<table_name>`.

Info

The _H table summarizes the data per hour.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column Name	Column Description
`ORFV_PWII_INSTANCE_ID`	ID of the database.
`ORFV_TIMESTAMP`	Timestamp of the sampling.
`ORFV_TS_ID`	Tablespace name of the file (`N PW_ORTB_TABLESPACE_N`).
`ORFV_FILE_ID`	File name (`N PW_ORFI_FILE_N`).
`ORFV_FILE_TYPE`	File type.
`ORFV_PYR_SUM`	Total number of physical reads done.
`ORFV_PYW_SUM`	Total number of times DBWR is required to write.
`ORFV_PRT_SUM`	Time spent on reads, in hundredths of a second.
`ORFV_PWT_SUM`	Time spent on writes, in hundredths of a second.
`ORFV_PBR_SUM`	Total number of physical blocks read.
`ORFV_PBW_SUM`	Total number of blocks written to disk, which may be the same as PHYWRTS if all writes are single blocks.
`ORFV_MINUTES_COUNT_SUM`	Total amount of minutes summed in the row.
`ORFV_PWHG_ID`	The hour group ID that matches the sampled time.
`ORFV_RECEIVED_TIMESTAMP`	The timestamp that the row was loaded into the PW.

PW_ORLA_V_LATCH_H

Store statistics for non-parent latches and summary statistics for parent latches.

Info
The `_H` table summarizes the data per hour. The `_D` table summarizes the data per day. The `_W` table summarizes the data per week. The `_M` table summarizes the data per month. `(N <table_name>)` means normalized, the actual name can be retrieved from the `<table_name>`.

Info

The _H table summarizes the data per hour.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column Name	Column Description
`ORLA_PWII_INSTANCE_ID`	ID of the database.
`ORLA_TIMESTAMP`	Timestamp of the sampling.
`ORLA_LATCH_NUM`	Number of the latch.
`ORLA_LEVEL_NUM`	Level of the latch.
`ORLA_LATCH_ID`	ID of the latch (`N PW_ORLT_LATCH_N`).
`ORLA_GETS_SUM`	Total number of times a wait was obtained.
`ORLA_MISSES_SUM`	Total number of times a wait was obtained, but failed on the first try.
`ORLA_SLEEPS_SUM`	Total number of times slept when wanting a wait.
`ORLA_IMMEDIATE_GETS_SUM`	Total number of times obtained without a wait.
`ORLA_IMMEDIATE_MISSES_SUM`	Total number of times failed to get without a wait.
`ORLA_WAITERS_WOKEN_SUM`	Total number of times a wait was awoken.
`ORLA_WAITS_HOLDING_LATCH_SUM`	Total number of waits, while holding a different latch.
`ORLA_SPIN_GETS_SUM`	Gets that missed the first try, but succeeded on spin.
`ORLA_MINUTES_COUNT_SUM`	Total amount of minutes summed in the row.
`ORLA_PWHG_ID`	The hour group ID that matches the sampled time.
`ORLA_RECEIVED_TIMESTAMP`	The timestamp that the row was loaded into the PW.

PW_ORLC_V_LICENSE_H

Stores information about the highest number of concurrent user sessions since the instance started.

Info
The `_H` table summarizes the data per hour. The `_D` table summarizes the data per day. The `_W` table summarizes the data per week. The `_M` table summarizes the data per month.

Info

The _H table summarizes the data per hour.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`ORLC_PWII_INSTANCE_ID`	ID of the database.
`ORLC_TIMESTAMP`	Timestamp of the sampling.
`ORLC_SESSIONS_HIGHWATER_SUM`	Highest number of concurrent user sessions since the instance started.
`ORLC_MINUTES_COUNT_SUM`	Total amount of minutes summed in the row.
`ORLC_PWHG_ID`	The hour group ID that matches the sampled time.
`ORLC_RECEIVED_TIMESTAMP`	The timestamp when the row was loaded into the PW.

PW_ORPQ_V_PQ_SYSSTAT_H

Stores system statistics for parallel queries.

Info
The `_H` table summarizes the data per hour. The `_D` table summarizes the data per day. The `_W` table summarizes the data per week. The `_M` table summarizes the data per month. `(N <table_name>)` means normalized, the actual name can be retrieved from the `<table_name>`.

Info

The _H table summarizes the data per hour.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column Name	Column Description
`OROT_PWII_INSTANCE_ID`	ID of the database.
`OROT_TIMESTAMP`	Date of the sampling.
`OROT_STATISTIC_ID`	Name of the statistic counter (`N PW_ORTI_STATISTIC_N`).
`OROT_VALUE_SUM`	Total value of the statistic counter.
`OROT_MINUTES_COUNT_SUM`	Total amount of minutes summed in the row.
`OROT_PWHG_ID`	The hour group ID that matches the sampled time.
`OROT_RECEIVED_TIMESTAMP`	The timestamp when the row was loaded into the PW.

PW_ORQU_V_QUEUE_H

Stores information on multi-thread message queues.

Info
The `_H` table summarizes the data per hour. The `_D` table summarizes the data per day. The `_W` table summarizes the data per week. The `_M` table summarizes the data per month. `(N <table_name>)` means normalized, the actual name can be retrieved from the `<table_name>`.

Info

The _H table summarizes the data per hour.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column Name	Column Description
`ORQU_PWII_INSTANCE_ID`	ID of the database (not null number (9)).
`ORQU_TIMESTAMP`	Date of the sampling (not null date).
`ORQU_NETWORK_ID`	Network address of the dispatcher (N PW_ORNT_NETWORK_N) (number (9)).
`ORQU_WAIT_SUM`	Total time that all items in this queue have waited. Divide this by TOTALQ for an average wait per item (number).
`ORQU_TOTALQ_SUM`	Total number of items that have ever been in the queue (number).
`ORQU_MINUTES_COUNT_SUM`	Total amount of minutes summed in the row (not null number (9)).
`ORQU_PWHG_ID`	The hour group ID that matches the sampled time (not null number (4)).
`ORQU_RECEIVED_TIMESTAMP`	The timestamp that the row was loaded into the PW.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools

Versions Compared

Old Version 18

New Version 19

Key

PW_ORFV_STAT_FILE_VIEW_H

PW_ORLA_V_LATCH_H

PW_ORLC_V_LICENSE_H

PW_ORPQ_V_PQ_SYSSTAT_H

PW_ORQU_V_QUEUE_H