invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

SYSTEMPSQLATOMICS: Data Dictionary PSQL Atomic Values

read only

  • Catalogue : DataDictionary
  • Schéma : Invantive
  • Label: PSQL Atomic Values

Named atomic values of the session (dbms_atomic), with their kind, size and contention statistics. Live session state rather than a log: the values are gone when the session ends, so a script wanting an audit trail past its session writes one itself. The accumulated text and the elements of a list are deliberately not shown; they are readable from the script through get_text and elements_text.

Permet uniquement de récupérer des données.

Colonnes de table

Les colonnes de la table SYSTEMPSQLATOMICS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
CONTENDED_COUNT int64 Nombre contesté Number of changes which had to wait for the session registry monitor.Zero means the value costs nothing.
CREATED_UTC datetime Créé Moment the name came into being.
ELEMENT_COUNT int64 Nombre d'éléments Number of elements in a list, or number of appends to a text.Empty for the NUMBER kind.
KIND varchar2 Kind Kind of the value, fixed when the name was created: NUMBER, TEXT or LIST OF TEXT.
LAST_MODIFIED_BY_INSTANCE varchar2 Dernière modification effectuée par Description of the worker frame which last changed the value: a parallel branch, a parallel loop worker or the main frame.
LAST_MODIFIED_UTC datetime Dernière modification (UTC) Moment the value was last changed.
NAME varchar2 Name Name of the atomic value (dbms_atomic).
NUMBER_VALUE numeric Value Current value, for the NUMBER kind.Empty for the other kinds.
OPERATION_COUNT int64 Nombre d'opérations Number of times the value was changed.Reads are not counted, so selecting this view does not change what it reports.
TOTAL_LENGTH int64 Longueur totale Number of characters accumulated.Reported instead of the content itself: a value built by a script can hold anything the script could compute, so the content is readable only from the script, through get_text and elements_text.
WAIT_DURATION_MS double Durée d'attente (ms) Total time changes of this value spent waiting for the session registry monitor.The count says how often the value was contended; this says what it cost.One monitor guards the whole session, so this is the wait experienced by operations on this name rather than necessarily the wait caused by them.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :