SYSTEMPARTITIONSTATISTICS: Data Dictionary System Partition Statistics
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: System Partition Statistics
Statistics per partitions for all active data containers.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMPARTITIONSTATISTICS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COMPANY_ |
datetime |
Bedrijf Verplaatsingsdatum Server (UTC) | Last server move date of the company. | ||
PROVIDER_ |
varchar2 |
Datacontainer Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Datacontainer ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provideromschrijving | Provider description. | ||
PROVIDER_ |
guid |
Providerinstantie UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Providernaam | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Korte Naam | Provider short name. | ||
PTN_ |
char |
Partitie Schrijven Toestaan | Whether the partition allows writes. | ||
PTN_ |
varchar2 |
Partitiecode | Unique code of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf Adres | Address of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijfsstad | City of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf KvK-nummer | Chamber of Commerce number of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf Land | Country of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Zakelijk E-mailadres | Email address of the company of the partition. | ||
PTN_ |
varchar2 |
Bedrijf IBAN Nummer | IBAN number of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijfsnaam | Name of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijfstelefoonnummer | Phone of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijfspostcode | ZIP-code of the company of the partition. | ||
PTN_ |
varchar2 |
Bedrijf RSIN Nummer | RSIN number of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf Staat | State of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf Twitteraccount | Twitter account of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf BTW-Nummer | VAT number of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf Loonheffingsnummer | Wage tax number of the company of the partition. | ||
PTN_ |
varchar2 |
Partitie Bedrijf Website | Web site of the company of the partition. | ||
PTN_ |
datetime |
Partitie Aangemaakt | When the partition was created (UTC). | ||
PTN_ |
varchar2 |
Partitie Omschrijving | Description. | ||
PTN_ |
datetime |
Partitie Eerste Gebruik | When the partition has been used first in this session (UTC). | ||
PTN_ |
guid |
Instantie-UID | Unique ID of the instance. | ||
PTN_ |
char |
Geselecteerde Partitie | Whether the partition is currently selected. | ||
PTN_ |
char |
Partitie Geselecteerd door Standaard | Whether the partition is selected by default. | ||
PTN_ |
char |
Gebruikte Partitie | Whether the partition has been used in this session. | ||
PTN_ |
varchar2 |
Partitie Label | Label for use in lists. | ||
PTN_ |
varchar2 |
Partitie Hoofdverdichting | Master roll-up. | ||
PTN_ |
datetime |
Partitie Gewijzigd | When the partition was last modified (UTC). | ||
PTN_ |
varchar2 |
Partitie Naam | Name. | ||
PTN_ |
varchar2 |
Partitie Verdichting | Roll-up. | ||
PTN_ |
datetime |
Laatst Gewijzigd Geselecteerd (UTC) | When the partition selection was last modified (UTC). | ||
PTN_ |
datetime |
Laatst Ingesteld Geselecteerd (UTC) | When the partition selection was last set (UTC). | ||
PTN_ |
datetime |
Laatst Niet-ingesteld Geselecteerd (UTC) | When the partition selection was last unset (UTC). | ||
PTN_ |
varchar2 |
Partitie Korte Naam | Short name. | ||
STC_ |
varchar2 |
Code | Unique code of the partition statistic. | ||
STC_ |
datetime |
Aanmaakdatum | Date at which the entry was originally created (UTC). | ||
STC_ |
varchar2 |
Description | Description of the partition statistic. | ||
STC_ |
char |
Is Standaard? | Is the statistic a standard statistic? | ||
STC_ |
varchar2 |
Verlaagde Nauwkeurigheidswaarde | Reduced accuracy value of the partition statistic. | ||
STC_ |
varchar2 |
Waardesoort | Type of value of the partition statistic. | ||
STC_ |
varchar2 |
Value | Value of the partition statistic. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SYSTEMPARTITIONSTATISTICS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: