SYSTEMPSQLATOMICS: Data Dictionary PSQL Atomic Values
read only
- Catalogo:
DataDictionary - Schema:
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.
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella SYSTEMPSQLATOMICS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CONTENDED_ |
int64 |
Conteggio contestato | Number of changes which had to wait for the session registry monitor.Zero means the value costs nothing. | ||
CREATED_ |
datetime |
Creato | Moment the name came into being. | ||
ELEMENT_ |
int64 |
Numero di elementi | 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_ |
varchar2 |
Ultima modifica a cura di | Description of the worker frame which last changed the value: a parallel branch, a parallel loop worker or the main frame. | ||
LAST_ |
datetime |
Ultima modifica (UTC) | Moment the value was last changed. | ||
NAME |
varchar2 |
Name | Name of the atomic value (dbms_atomic). | ||
NUMBER_ |
numeric |
Value | Current value, for the NUMBER kind.Empty for the other kinds. | ||
OPERATION_ |
int64 |
Conteggio delle operazioni | Number of times the value was changed.Reads are not counted, so selecting this view does not change what it reports. | ||
TOTAL_ |
int64 |
Lunghezza 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_ |
double |
Durata dell'attesa (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. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: