SYSTEMPARTITIONSTATISTICS: Data Dictionary System Partition Statistics
read only
- Katalog:
DataDictionary - Schema:
Invantive - Label: System Partition Statistics
Statistics per partitions for all active data containers.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle SYSTEMPARTITIONSTATISTICS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COMPANY_ |
datetime |
Firma Umzugsdatum Server (UTC) | Last server move date of the company. | ||
PROVIDER_ |
varchar2 |
Datencontaineralias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Datenkontainer ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Treiberbeschreibung | Provider description. | ||
PROVIDER_ |
guid |
Treiber Instanz-UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Anbietername | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Treiber Kurzname | Provider short name. | ||
PTN_ |
char |
Partition für Schreibzugriffe freigeben | Whether the partition allows writes. | ||
PTN_ |
varchar2 |
Partitionscode | Unique code of the partition. | ||
PTN_ |
varchar2 |
Partition Firmenadresse | Address of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Firmenstadt | City of the company of the partition. | ||
PTN_ |
varchar2 |
CoC-Nummer der Partition Company | Chamber of Commerce number of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Unternehmen Land | Country of the company of the partition. | ||
PTN_ |
varchar2 |
E-Mail-Adresse der Firma „Partition“ | Email address of the company of the partition. | ||
PTN_ |
varchar2 |
IBAN-Nummer des Unternehmens | IBAN number of the company of the partition. | ||
PTN_ |
varchar2 |
Name des Unternehmens „Partition“ | Name of the company of the partition. | ||
PTN_ |
varchar2 |
Telefonnummer der Firma „Partition“ | Phone of the company of the partition. | ||
PTN_ |
varchar2 |
Ort, Firma, Postleitzahl | ZIP-code of the company of the partition. | ||
PTN_ |
varchar2 |
Unternehmen RSIN-Nummer | RSIN number of the company of the partition. | ||
PTN_ |
varchar2 |
Bundesland der Firma „Partition“ | State of the company of the partition. | ||
PTN_ |
varchar2 |
Twitter-Konto der Firma Partition | Twitter account of the company of the partition. | ||
PTN_ |
varchar2 |
Umsatzsteuer-Identifikationsnummer der Partition Company | VAT number of the company of the partition. | ||
PTN_ |
varchar2 |
Steuernummer der Zweigniederlassung für Lohnsteuer | Wage tax number of the company of the partition. | ||
PTN_ |
varchar2 |
Website der Firma Partition | Web site of the company of the partition. | ||
PTN_ |
datetime |
Partition erstellt | When the partition was created (UTC). | ||
PTN_ |
varchar2 |
Beschreibung der Partition | Description. | ||
PTN_ |
datetime |
Partition – Erste Verwendung | When the partition has been used first in this session (UTC). | ||
PTN_ |
guid |
Instanz-UID | Unique ID of the instance. | ||
PTN_ |
char |
Ausgewählte Partition | Whether the partition is currently selected. | ||
PTN_ |
char |
Partition standardmäßig ausgewählt | Whether the partition is selected by default. | ||
PTN_ |
char |
Verwendete Partition | Whether the partition has been used in this session. | ||
PTN_ |
varchar2 |
Partition-Bezeichnung | Label for use in lists. | ||
PTN_ |
varchar2 |
Partition Master – Roll-up | Master roll-up. | ||
PTN_ |
datetime |
Partition geändert | When the partition was last modified (UTC). | ||
PTN_ |
varchar2 |
Partitionenamen | Name. | ||
PTN_ |
varchar2 |
Rollvorhang-Partition | Roll-up. | ||
PTN_ |
datetime |
Ausgewählt – Letzte Änderung (UTC) | When the partition selection was last modified (UTC). | ||
PTN_ |
datetime |
Ausgewählter letzter Satz (UTC) | When the partition selection was last set (UTC). | ||
PTN_ |
datetime |
Ausgewählt – Zuletzt nicht festgelegt (UTC) | When the partition selection was last unset (UTC). | ||
PTN_ |
varchar2 |
Kurzbezeichnung der Partition | Short name. | ||
STC_ |
varchar2 |
Code | Unique code of the partition statistic. | ||
STC_ |
datetime |
Datum erstellen | Date at which the entry was originally created (UTC). | ||
STC_ |
varchar2 |
Description | Description of the partition statistic. | ||
STC_ |
char |
Ist Standard? | Is the statistic a standard statistic? | ||
STC_ |
varchar2 |
Reduzierter Genauigkeitswert | Reduced accuracy value of the partition statistic. | ||
STC_ |
varchar2 |
Wert Typ | Type of value of the partition statistic. | ||
STC_ |
varchar2 |
Value | Value of the partition statistic. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
SYSTEMPARTITIONSTATISTICS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: