Open topic with navigation
A pseudo table generated to show all atomThe internal object structure representing all data in a NuoDB database. Atoms are self-coordinating objects that represent specific types of information (such as data, indexes or schemas).s that are currently cached on all running database process nodes (transaction engines and storage managers). Since a particular atom can be on multiple nodes, there might be multiple rows for the same atom — one row for each node that the atom is on. Each row for the same atom has a different value in the
The information in this table can be useful for debugging and for understanding application performance. Viewing all information in this table can generate a very large result set.
Caution: Client applications should never contain code that accesses
SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
|OBJECTID||integer||A unique ID that identifies the database object.|
|CATALOGID||integer||The catalog ID for the database object.|
|OBJECTTYPE||string||The type of database object, one of:
|STORAGEGROUPID||bigint||The ID of the storage group where this atom resides.|
|POPULATED||boolean||An internal flag that indicates the state of the atom.|
|OPEN||boolean||An internal flag that indicates the state of the atom.|
|COMPLETE||boolean||An internal flag that indicates the state of the atom.|
|REFCOUNT||integer||An internal reference count for this atom.|
A unique number associated with each cached object. This number increases when an object is dropped and reloaded.
|CONTENTSIZE||bigint||An internal estimation of object size. Do not use this to compute size on disk or memory consumption.|
|CHAIRMAN||integer||The node ID of the chairman for this atom.|
|REQUESTEDFROM||integer||The node ID of the database process (transaction engine or storage manager) that requested this atom.|
|DIRTY||boolean||A value of true indicates that this atom has data that needs to be recorded by the storage manager.|
|NODEID||integer||The ID of the database process where this atom resides.|