Virtual Table

The Virtual Tables are virtual tables that represent various operational information of the Machbase server in the form of a table. The names of these tables begin with “V$”.

This data is used to know what state the Machbase server is operating in. In addition, various information can be obtained through JOIN operation with other tables in this virtual table.

Virtual Tables are read-only and can not be added / deleted / updated by the user.

Index

Session/System
V$SYSMEM
Result Cache
- V$RS_CACHE_LIST
- V$RS_CACHE_STAT
Storage
Log Table
LSM(Log Structured Merge) Index
Volatile Table
- V$STORAGE_DC_VOLATILE_TABLE
Tag Table
Tag Rollup
- V$ROLLUP
Stream
- V$STREAMS
License
- V$LICENSE_INFO
- V$LICENSE_STATUS
Mutex
- V$MUTEX
- V$MUTEX_WAIT_STAT
Cluster
Others

Session/System

V$PROPERTY

Displays the property information set in the server.

Column Name	Description
NAME	Property name
VALUE	Property value
TYPE	Data type
DEFLT	Default value
MIN	Minimum set value
MAX	Maximum set value

V$SESSION

Displays session information connected to the Machbase server.

Column Name	Description
HOSTNAME (Cluster Only)	Name of the HOST which the session is connected.
ID	Session identifier
CLOSED	Whether connection is closed
USER_ID	User identifier
LOGIN_TIME	Connection time
CLIENT_TYPE	Connected client type
USER_NAME	User name
USER_IP	User IP address
SQL_LOGGING	Leave message in session trace log status 1: Leaves errors occurring in the Parsing, Validation, Optimization steps 2: Leaves result performance of DDL 3: (Leaves both cases above)
SHOW_HIDDEN_COLS	Whether hidden columns are shown upon SELECT
FEEDBACK_APPEND_ERROR	Whether there is feedback to client on APPEND error
DEFAULT_DATE_FORMAT	Default input format upon Datetime input
HASH_BUCKET_SIZE	Number of Buckets in Temp Hashtable created when performing query
MAX_QPX_MEM	Maximum memory size available when performing query
RS_CACHE_ENABLE	Whether Result Cache in in use
RS_CACHE_TIME_BOUND_MSEC	Maximum elapsed time to store results when using Result Cache
RS_CACHE_MAX_MEMORY_PER_QUERY	Maximum size of memory used per query when using Result Cache
RS_CACHE_MAX_RECORD_PER_QUERY	Maximum number of results used per query when using Result Cache
RS_CACHE_APPROXIMATE_RESULT_ENABLE	Whether to cache approximate query results when using Result Cache
IDLE_TIMEOUT	Terminate the session if the client does nothing for that time after the session connected.
QUERY_TIMEOUT	Response waiting time for query execution

V$SESMEM

Displays session memory information.

Column Name	Description
SID	Session identifier
ID	Memory manager identifier
USAGE	Usage size

V$SESSTAT

Displays statistical information of the session.

Column Name	Description
SID	Session identifier
ID	Statistical information identifier
VALUE	Statistical information value

V$SESTIME

Displays the time information of the session.

Column Name	Description
SID	Session identifier
ID	Performance unit identifier
ACCUM_TICK	Cumulative time
MAX_TICK	Maximum time (per each performance unit)

V$SYSMEM

Displays memory information of the system.

Column Name	Description
ID	Memory manager identifier
NAME	Memory manager name
USAGE	Current usage
MAX_USAGE	(Recorded) Maximum usage

V$SYSSTAT

Displays statistical information of the system.

Column Name	Description
ID	Statistical information identifier
NAME	Statistical information name
VALUE	Statistical information value

V$SYSTIME

Displays the time information of the system.

Column Name	Description
ID	Performance unit identifier
NAME	Performance unit name
ACCUM_TICK	Cumulative time
AVG_TICK	Average time (per each performance unit)
MIN_TICK	Minimum Time (per each performance unit)
MAX_TICK	Maximum Time (per each performance unit)
COUNT	Performance frequency

V$STMT

Displays information about the query statement that the user is currently executing.

Column Name	Description
ID	Query identifier
SESS_ID	Performed query session identifier
STATE	Query status
RECORD_SIZE	Resulting record size of select statements
QUERY	Query statement

V$VERSION

Displays information about Machbase version.

Column Name	Description
BINARY_DB_MAJOR_VERSION	Database major version
BINARY_DB_MINOR_VERSION	Database minor version
BINARY_META_MAJOR_VERSION	META major version
BINARY_META_MINOR_VERSION	META minor version
BINARY_CM_MAJOR_VERSION	Client (Communication Level) major version
BINARY_CM_MINOR_VERSION	Client (Communication Level) minor version
BINARY_SIGNATURE	Version name of DB data files.
FILE_DB_MAJOR_VERSION	File DB major version
FILE_DB_MINOR_VERSION	File DB minor version
FILE_META_MAJOR_VERSION	File META major version
FILE_META_MINOR_VERSION	File META minor version
FILE_CM_MAJOR_VERSION	File Client (Communication Level) major version
FILE_CM_MINOR_VERSION	File Client (Communication Level) minor version
FILE_CREATE_TIME	File creation time
EDITION	Machbase type

Result Cache

V$RS_CACHE_LIST

Display the result cache list.

Column Name	Description
TOUCH_TIME	Time cache was used or created
USER_ID	Cache user identifier
QUERY	Cache query statement
TIME_SPENT	Time spent producing result
TABLE_COUNT	Number of tables associated with query statement
RECORD_COUNT	Number of result records
REFERENCE_COUNT	Number of sessions currently being referenced
HIT_COUNT	Cache hit count
AGGR_TOUCH_TIME	Time the cache was used or created for aggregate results
AGGR_HIT_COUNT	Cache hit count for aggregate results

V$RS_CACHE_STAT

Display statistical information of result cache in one session.

Column Name	Description
CACHE_COUNT	Number of result caches
CACHE_HIT	Total cache hit count
AGGR_HIT	Total cache hit count for aggregate results
CACHE_REPLACED	Cache replacement count
CACHE_MEMORY_USAGE	Size of cache memory used

Storage

V$STORAGE

Displays internal information of the storage system.

Column Name	Description
DC_TABLE_FILE_SIZE	Total capacity of disk column data
DC_INDEX_FILE_SIZE	Total capacity of index file data
DC_TABLESPACE_DWFILE_SIZE	Total capacity of DWFILE for all column data
DC_KV_TABLE_FILE_SIZE	Total number of data files of TAGDATA table partition tables

V$STORAGE_MOUNT_DATABASES

Displays the information of the mounted backup database using the mount function.

Column Name	Description
NAME	Mounted database name
PATH	Backup file location
BACKUP_TBSID	Backup database tablespace identifier
BACKUP_SCN	Backup database identifier
MOUNTDB	Backup time
DB_BEGIN_TIME	Backup database first entry time
DB_END_TIME	Backup database last entry time
BACKUP_BEGIN_TIME	Backup begin time
BACKUP_END_TIME	Backup end time
FLAG	Property flag

V$CACHE

Displays the comprehensive information on the cache objects containing the results read from the storage system.

Column Name	Description
OBJ_COUNT	Current number of result set cache objects

V$CACHE_OBJECTS

Displays information about each cache object that contains the results read from the storage system.

Column Name	Description
OID	Object identifier
REF_COUNT	Reference count
FLAG	(Internal server use flag)

V$STORAGE_DC_TABLESPACES

Displays the table space information of the storage system.

Column Name	Description
NAME	Tablespace name
ID	Tablespace identifier
FLAG	Flag indicating tablespace property
REF_COUNT	Tablespace reference count
DISK_COUNT	Tablespace disk count

V$STORAGE_DC_TABLESPACE_DISKS

Displays the table space information of the storage system.

Column Name	Description
NAME	Disk name
ID	Disk identifier
TABLESPACE_ID	Disk tablespace identifier
PATH	Disk path
IO_THREAD_COUNT	I/O Thread count
IO_JOB_COUNT	I/O Job count
VIRTUAL_DISK_COUNT	Virtual disk count

V$STORAGE_DC_DWFILES

Displays the information of the double-write file (DW File) operated by the storage system.

Column Name	Description
TBS_ID	Tablespace identifier
DISK_ID	Disk identifier
FILE	File path
TABLE_ID	Table identifier
COLUMN_ID	Column identifier
PARTITION_ID	Partition identifier
PAGE_ID	Page identifier
DISK_OFFSET	Disk offset
DISK_IMAGE_SIZE	Disk image size
HEAD_CRC32CODE_IMAGE	Head CRC32 Code Image
TAIL_CRC32CODE_IMAGE	Tail CRC32 Code Image
CRC32CODE_PAGE	CRC32 Code Page
HEAD_TIMESTAMP_PAGE	Head Timestamp Page
TAIL_TIMESTAMP_PAGE	Tail Timestamp Page

V$STORAGE_DC_PAGECACHE

Displays information about the Page Cache operating on the storage system

Column Name	Description
MAX_MEM_SIZE	Maximum memory size of Page Cache
CUR_MEM_SIZE	Current memory size of Page Cache
PAGE_CNT	Number of cached pages
CHECK_TIME	Check time

V$STORAGE_DC_PAGECACHE_LRU_LST

Displays information about the LRU List of Page Cache operated by the storage system.

Column Name	Description
OBJECT_ID	Object identifier
LEVEL	Partition level
PARTITION_ID	Partition identifier
OFFSET	Page Cache Offset
SIZE	Page size
REF_CNT	Reference count

V$STORAGE_USAGE

Displays the amount of storage used by the storage system.

Column Name	Description
TOTAL_SPACE	Total storage capacity where the $MACHBASE_HOME/dbs directory is located
USED_SPACE	Total storage usage where the $MACHBASE_HOME/dbs directory is located
USED_RATIO	Percentage of usage(%)
RATIO_CAP	Storage usage limit. Data input/index construction stops when USED_RATIO reaches this limit.

V$STORAGE_TABLES

Display table details.

Column Name	Description
ID	Table ID
TYPE	Table type - Persistent: LOG / TAG Table - Volatile: Volatile Table - Key-Value: Accompanying table of TAG table
STATUS	Current Status - Creating…: Creating table by CREATE TABLE query - Normal: normal - Predrop: DROP TABLE query accepted - Dropping…: DROP TABLE query processing - Dropped: DROP TABLE query completed - Mounted: The backed up database loaded with the MOUNT query
STORAGE_USAGE	Capacity occupied by the table in storage

Log Table

V$STORAGE_DC_TABLES

Displays internal information about Log Table.

Column Name	Description
ID	Table identifier
DATABASE_ID	Database identifier
CREATE_SCN	System Change Number at time of creation
UPDATE_SCN	System Change Number at time of most recent update
DDL_REF_COUNT	Number of sessions referencing table in DDL syntax execution
BEGIN_RID	Minimum table RID
END_RID	Last row ID of table + 1
BEGIN_META_RID	ID at start of recording meta information
END_META_RID	ID at end of recording meta information
END_SYNC_RID	Last row ID recorded on disk + 1
FLAG	Flag indicating table property
COLUMN_COUNT	Table column count
INDEX_COUNT	Table index count
INDEX_MIN_END_RID	Last RID recorded in index + 1
LAST_ARRIVAL_TIME	Last recorded _arrival_time value
LAST_CHECKPOINT_TIME	Last checkpoint time
TYPE	Table type

V$STORAGE_DC_TABLES_STAT

Displays internal information about Log Table.

Column Name	Description
TABLESPACE_ID	Tablespace identifier
TABLE_ID	Table identifier
COLUMN_ID	Column identifier
COUNT	Record count

V$STORAGE_DC_TABLE_COLUMNS

Displays information about the columns in the Log Table.

Column Name	Description
TABLE_ID	Table identifier
DATABASE_ID	Database identifier
ID	Column identifier
FLAG	Property flag
SIZE	Column data size
PARTITION_VALUE_COUNT	Maximum number of data stored in partition
PAGE_VALUE_COUNT	Maximum number of data stored in page
CACHE_VALUE_COUNT	Maximum number of cache values
MINMAX_CACHE_SIZE	Maximum size of MIN / MAX cache for column partitions
CUR_APPEND_PARTITION_ID	Current partition in progress of input identifier
CUR_CACHE_PARTITION_COUNT	Number of partitions that have read data in current cache
CUR_MINMAX_CACHE_SIZE	Current Min / MAX cache size
END_RID_FOR_DEFAULT_VALUE	Location value of end rid maintaining default value
DISK_FILE_SIZE	Total size of column partition data file for that column
MEMORY_TOTAL_SIZE	Memory size used by table
MEMORY_ALLOC_SIZE	Memory size allocated by table

V$STORAGE_DC_TABLE_COLUMN_PARTS

Displays column partition information of log table.

Column Name	Description
TABLE_ID	Table identifier
DATABASE_ID	Database identifier
COLUMN_ID	Column identifier
ID	Partition identifier
FLAG	Flag indicating column property
BEGIN_RID	First RID stored in partition
END_RID	Last RID stored in partition
END_SYNC_RID	Last RID SYNC ended. Data with a RID greater than the starting RID and less than the last SYNC RID is recorded in the partition file.
MIN_TIME	First time data was entered into column partition
MAX_TIME	Last time data was entered into column partition
MAX_VALUE_COUNT_PER_PARTITION	Maximum partition data count
MAX_VALUE_COUNT_PER_PAGE	Maximum page data count
MAX_PAGE_COUNT	Maximum partition page count
PAGE_SIZE	Page size stored in column partition
PAGE_COUNT	Page count created in current column partition
COMPRESS_RATIO	Column partition compression ratio. If it is 0, data compression has not been performed yet.
DISK_FILENAME	Partition file name
EXTERNAL_PART_SIZE	A large amount of data is written to the external partition file, indicating the size of the file
MIN_VALUE	Minimum column partition value
MAX_VALUE	Maximum column partition value

V$STORAGE_DC_TABLE_INDEXES

Displays index information generated in Log Table.

Column Name	Description
TABLE_ID	Table identifier
DATABASE_ID	Database identifier
ID	Index identifier
FLAG	Flag indicating index property
TABLE_BEGIN_RID	First RID entered into table
TABLE_END_RID	Last table RID
BEGIN_RID	First index RID
END_RID	Last index RID
END_SYNC_RID	Last recorded RID in file + 1
COLUMN_COUNT	Index column count
BEGIN_PART_ID	Index first partition identifier
END_PART_ID	Index last partition identifier
FLUSH_REQUEST_COUNT	Number of index partitions requested to reflect on disk
MAX_KEY_SIZE	Maximum key size
INDEX_TYPE	Index type
DISK_FILE_SIZE	Total size of index partition file for that index
LAST_CHECKPOINT_TIME	Last checkpoint time

LSM(Log Structured Merge) Index

V$STORAGE_DC_LSMINDEX_LEVEL_PARTS

Displays information about LSM Index partitions.

Column Name	Description
TABLE ID	Index table identifier
TABLESPACE_ID	Tablespace identifier
INDEX_ID	Index identifier
LEVEL	Index partition LSM level
PARTITION_ID	Partition identifier
BEGIN_RID	First RID entered into partition
END_RID	Last RID entered into partition + 1
KEY_VALUE_COUNT	Key value count entered into partition
KEY_VALUE_TABLE_SIZE	Size of page storing key value
KEY_VALUE_TABLE_PAGE_COUNT	Number of pages storing key value
MIN_KEY_VALUE	Minimum key value
MAX_KEY_VALUE	Maximum key value
BITMAP_TABLE_SIZE	Total size of page storing bitmap value
BITMAP_TABLE_PAGE_COUNT	Number of pages storing bitmap value
META_SIZE	Total size of page storing meta information
META_PAGE_COUNT	Number of pages storing meta information
TOTAL_BUILD_MSEC	Total time to complete partition
KEYVAL_BUILD_MSEC	Total time to complete partition for KeyValue Mode
BITMAP_BUILD_MSEC	Total time to complete partition for Bitmap Mode

V$STORAGE_DC_LSMINDEX_LEVEL_PARTS_CACHE

Displays information about the LSM Index partition cache.

Column Name	Description
TABLESPACE_ID	Tablespace identifier
TABLE_ID	Index Table identifier
INDEX_ID	Index identifier
LEVEL	Index partition LSM level
PARTITION_ID	Partition identifier
BEGIN_RID	First RID entered into partition
END_RID	Last RID entered into partition + 1
KEY_VALUE_COUNT	Number of key values entered into partition
KEY_VALUE_TABLE_SIZE	Size of page storing key value
KEY_VALUE_TABLE_PAGE_COUNT	Number of pages storing key value
BITMAP_TABLE_SIZE	Total size of page storing bitmap value
BITMAP_TABLE_PAGE_COUNT	Number of pages storing bitmap value
META_SIZE	Total size of page storing meta information
META_PAGE_COUNT	Number of pages storing meta information
MEMORY_SIZE	Memory usage
MEMORY_SIZE_RBTREE	Redblack Tree memory usage

V$STORAGE_DC_LSMINDEX_LEVELS

Displays information about the level of the LSM index.

Column Name	Description
TABLE ID	Table identifier
DATABASE_ID	Database identifier
INDEX_ID	Index identifier
LEVEL	Level
BEGIN_RID	First partition RID
END_RID	Last partition RID + 1
META_BEGIN_RID	RID at start time of recording meta information
META_END_RID	RID at end time of recording meta information
DELETE_END_RID	Maximum deleted RID + 1

V$STORAGE_DC_LSMINDEX_FILES

Displays information about the files that make up the LSM Index.

Column Name	Description
TABLE_ID	Table identifier
DATABASE_ID	Database identifier
INDEX_ID	Index identifier
LEVEL	Index partition LSM level
PARTITION_ID	Partition identifier
BEGIN_RID	Partition first RID
END_RID	Partition last RID + 1
PATH	Index file location

V$STORAGE_DC_LSMINDEX_AGER_JOBS

Displays working status of Ager responsible for LSM Index deletion.

Column Name	Description
TABLE_ID	Table identifier
INDEX_ID	Index identifier
LEVEL	Index partition LSM level
BEGIN_RID	First partition RID
END_RID	Last partition RID + 1
STATE	Index Ager working status

Volatile Table

V$STORAGE_DC_VOLATILE_TABLE

Displays information about Volatile Table.

Column Name	Description
MAX_MEM_SIZE	Maximum Volatile Tablespace size
CUR_MEM_SIZE	Current Volatile Tablespace size

Tag Table

V$STORAGE_TAG_TABLES

Displays information about the partition table in the Tagdata Table.

Column Name	Description
ID	Table identifier
TABLE_BEGIN_RID	Table start RID
TABLE_END_RID	Table end RID
WRITE_END_RID	Last RID which is written to data file.
EXT_ROW_COUNT	Number of entries to external partitions in VARCHAR records
EXT_WRITE_COUNT	Number of entries to data files in VARCHAR records
DISK_INDEX_END_RID	Index end RID stored in storage
MEMORY_INDEX_END_RID	Table end RID in memory index
DELETE_MIN_DATE	Minimum time of deleted data by execute DELETE BETWEEN query
DELETE_MAX_DATE	Maximum time of deleted data by execute DELETE BETWEEN/BEFORE query
INDEX_STATE	Current Index Build Stats - IDLE: Build Complete, waiting - PROGRESS: Build in progress - IOWAIT: Waiting for I/O operation in storage - PENDING: Waiting for table read lock - SHUTDOWN: Stopped. DELETE operation or DROP operation in progress. - ABNORMAL: Abnormal end
DELETE_STATE	Current DELETE operation state. There is no IDLE because it is performed only when a DELETE command is entered. - PROGRESS: Deletion in progress - IOWAIT: Waiting for I/O operation in storage - PENDING: Waiting for table read/write lock - SHUTDOWN: Stopped. DELETE operation or DROP operation in progress. - ABNORMAL: Abnormal end
SAVE_STATE	Current Table Save operation state. - IDLE: Save Complete, waiting - PROGRESS: Save in progress - IOWAIT: Waiting for I/O operation in storage - PENDING: Waiting for table read lock - SHUTDOWN: Stopped. DELETE operation or DROP operation in progress. - ABNORMAL: Abnormal end

V$STORAGE_TAG_CACHE

Displays the cache information used in the partition table of the Tagdata Table.

Column Name	Description
CATEGORY	Type of object in cache
USED_MEMORY	Size of memory in use
BLOCK_COUNT	Data cache count
CACHE_HIT	Data cache hit count
CACHE_MISS	Data cache miss count
FLUSHOUT	Number of page flushouts due to data cache crash
COLDREAD	Number of data pages read directly from storage
MEMORY_WAIT	Number of times data memory waited for cache crash
IO_WAIT	Data read operation wait count

V$STORAGE_TAG_CACHE_OBJECTS

Displays detailed information about each cache block used in the partition table of the Tagdata Table.

Column Name	Description
CATEGORY	Object classification being cached
LATEST_HIT	Last approach time
STATUS	Cache status - None: Memory allocation done - Resides: Already stored in cache - Loading: Loading table data from storage - ERROR!: Error appears while loading data
WAIT_COUNT	The number of waiting times because the cache could not be read in the Loading state
REF_COUNT	Number of sessions currently referencing the cache block
HIT_COUNT	Number of times a cache block was referenced
TABLE_ID	Table Identifier
FILE_ID	File Identifier
PART_ID	Partition identifier inside the datafile
SAVE_SCN	SCN of table save
VSAVE_SCN	SCN of table save
DELETE_SCN	SCN of delete operation
OFFSET	Datafile offset
DATA_SIZE	Data size before compression, or 0

V$STORAGE_TAG_TABLE_FILES

Displays the file information of the partition table of the Tag Table.

Column Name	Description
TABLE_ID	Table identifier
FILE_ID	File identifier
STATE	Index status - COMPLETE: Data stored, index build complete - INDEXING: Index build in progress - FILLED: Data is full, waiting for Index build - PARTIAL: Data not yet full, waiting for Index build
REF_COUNT	Number of sessions currently referencing the file
ROW_COUNT	Number of records stored in the file, including those that were deleted
DEL_COUNT	Number of records deleted from the file
MIN_DATE	Minimum datatime value of this data file.
MAX_DATE	Maximum datatime value of this data file.

V$STORAGE_TAG_INDEX

Displays index information generated in Tag Table.

Column Name	Description
TABLE_ID	Table identifier
INDEX_ID	Index identifier (if INDEX_ID is 4294967295 it is a default index that is created automatically when the tag table is created.)
INDEX_STATE	Current index build state - IDLE: Build Complete, waiting - INDEXING: Build in progress - STORAGE FULL: Stopped because of disk full
DISK_INDEX_END_RID	Index end RID stored in storage
MEMORY_INDEX_END_RID	Table end RID in memory index
TABLE_END_RID	Table end RID

Tag Rollup

V$ROLLUP

Displays the Rollup information that stores information of the Tagdata table.

Column Name	Description
ID	Rollup job ID
ROLLUP_TABLE_NAME	Table name to store Rollup information
SOURCE_TABLE_NAME	Name of tag table that Rollup will query
USER_ID	User ID of Rollup Table and Source Table
ROOT_TABLE	Root Source Table Name
INTERVAL	Rollup execution cycle (sec)
END_RID	Source Table end RID
ENABLED	Indicates Rollup progress status
LAST_ELAPSED_MSEC	Number of recently entered records

Stream

V$STREAMS

Column Name	Description
NAME	The name of stream query.
LAST_EX_TIME	Last execution time of this query.
TABLE_NAME	The name of table which searched from the query
END_RID	The last RID read by stream query
STATE	Current state of stream query
QUERY_TXT	Query text
ERROR_MSG	Error message of the last stream execution
FREQUENCY	Minimum wait time for query execution. If it is 0, it is executed every record. If it is not 0, it is executed each time. The unit is nanoseconds.

License

V$LICENSE_INFO

Displays license information.

Column Name	Description
INSTALL_DATE	Installation date
TYPE	License type
POLICY	License policy type
CUSTOMER	Customer name
ISSUE_DATE	Issue date
ID	Host ID
EXPIRY_DATE	Expiration date
SIZE_LIMIT	Work input limit
ADDENDUM	Additional data rate
VIOLATION_ACTION	Indicates license violation
VIOLATION_LIMIT	Number of violations to suspend service (monthly update)
STOP_ACTION	Indicates database is terminated in the event of license violation
RESET_FLAG	(Internal server use)

V$LICENSE_STATUS

Displays the license status.

Column Name	Description
USER_DATA_PER_DAY	Amount of data that can be entered per day
PREVIOUS_CHECK_DATE	Previous license check date
VIOLATION_COUNT	License violation count
STOP_ENABLED	Display whether license restrictions are enabled or not.

Mutex

V$MUTEX

Displays current mutex status.

Column Name	Description	Note
OBJECT	Address of the mutex object
NAME	The name given when creating the mutex
TYPE	Mutex type	- Mutex: pmuMutex - RW Mutex: pmuRWMutex
OWNER	ID of the thread that acquired the mutex	- Mutex: 0 if no thread acquired the mutex. - RW Mutex w/ Read-Lock: 0 - RW Mutex w/ Write-Lock: ID of the thread that acquired the write lock.
LOCK_COUNT	Number of threads that acquired the mutex	- RW Mutex can be 2 or more.
PEND_COUNT	Number of threads waiting to acquire a mutex	- Collect only when TRACE_MUTEX_WAIT_STATUS=1
TRY_COUNT	Number of attempts to acquire the mutex	- Collect only when TRACE_MUTEX_WAIT_STATUS=1
CONFLICT_COUNT	Number of failed to acquire mutex	- Collect only when TRACE_MUTEX_WAIT_STATUS=1
WAIT_TICK	Sum of waiting time to acquire mutex	- Collect only when TRACE_MUTEX_WAIT_STATUS - Do not write to RW Mutex
WAIT_TICK_AVG	Average time to success after an attempt to acquire a mutex	- Collect only when TRACE_MUTEX_WAIT_STATUS=1 - Do not write to RW Mutex
HELD_TICK	Total time from acquiring the mutex to releasing it	- Collect only when TRACE_MUTEX_WAIT_STATUS=1 - Do not write to RW Mutex
HELD_TICK_AVG	Average time from acquisition to release of mutex	- Collect only when TRACE_MUTEX_WAIT_STATUS=1 - Do not write to RW Mutex

V$MUTEX_WAIT_STAT

Shows the call stack of the currently waiting mutex.

Column Name	Description	Note
THREAD_ID	ID of the thread waiting to acquire the mutex
OBJECT	Address of the mutex being acquired	- Same as OBJECT in V$MUTEX
DEPTH	Call stack depth	- Collect only when TRACE_MUTEX_WAIT_STATUS=1
SYMBOL	Symbol of function that called acquire mutex	- Collect only when TRACE_MUTEX_WAIT_STATUS=1

Cluster

V$NODE_STATUS

Displays the Node status for each Cluster. Only one is displayed.

Column Name	Description
NODETYPE	Node type. There are two types that can be viewed by queries. - Broker - Warehouse
STATE	Node status

V$DDL_INFO

Displays DDL information performed by Cluster.

Column Name	Description
SEQUENCENUMBER	DDL sequence number
TIME	DDL execution time
VALUE	DDL query result value (Internal server use)
CLIENT	Client name
BROKER	Lead Broker Node name
USER	User name
SQL	DDL query value

V$REPLICATION

Displays information about the replication operation.

Column Name	Description
HOSTNAME	Replication Node Hostname
MODE	(Internal server use)
STATE	Node status
ADDR	Replication Manager address
PORT_NO	Replication Manager port number
MAX_SENDER_COUNT	Maximum number of Senders that can be created
RUN_SENDER_COUNT	Maximum number of active Senders

V$REPL_SENDER

Displays Sender replication when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
ID	Sender identifier
STATUS	Sender operational status
PAYLOAD_RECV_COUNT	Number of payloads received from sender
PAYLOAD_RECV_BYTES	Total payload size received from Sender
QUEUE_REMAIN_COUNT	Number of buffers remaining in the Receive Queue
NET_SEND_COUNT	Net send count
NET_SEND_SIZE	Net send size
NET_RECV_COUNT	Net receive count
NET_RECV_SIZE	Net receive size

V$REPL_SENDER_META

Displays Sender metadata when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
SENDER_ID	Sender identifier
TABLE_ID	Target table identifier
TABLE_TYPE	Target table type
BEGIN_RID	Target record start RID
END_RID	Target record end RID

V$REPL_RECEIVER

Displays Receiver information when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
STATUS	Receiver operational status
PAYLOAD_RECV_COUNT	Number of payloads received from sender
PAYLOAD_RECV_BYTES	Total payload size received from Sender
QUEUE_REMAIN_COUNT	Number of buffers remaining in the Receive Queue
NET_SEND_COUNT	Net send count
NET_SEND_SIZE	Net send size
NET_RECV_COUNT	Net receive count
NET_RECV_SIZE	Net receive size

V$REPL_RECEIVER_META

Displays Receiver metadata when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
TABLE_ID	Target table identifier
TABLE_TYPE	Target table type
BEGIN_RID	Target record start RID
END_RID	Target record end RID

V$REPL_READER

Displays Reader information when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
SENDER_ID	Sender identifier
ID	Reader identifier
STATUS	Reader operation status
FETCH_COUNT	FETCH count

V$REPL_READER_META

Displays Reader metadata when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
SENDER_ID	Sender identifier
ID	Reader identifier
TABLE_ID	Target table identifier
TABLE_TYPE	Target table type
BEGIN_RID	Target record start RID
END_RID	Target record end RID

V$REPL_WRITER

Displays Writer information when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
ID	Writer identifier
STATUS	Writer operational status
APPEND_COUNT	APPEND count

V$REPL_WRITER_META

Displays Writer metadata when running Replication.

Column Name	Description
HOSTNAME	Replication Node Hostname
ID	Writer identifier
TABLE_ID	Target table identifier
TABLE_TYPE	Target table type
BEGIN_RID	Target record start RID
END_RID	Target record end RID

Others

V$TABLES

Displays all Virtual Tables that start with “V$”.

Column Name	Description
NAME	Table name
TYPE	Table type
DATABASE_ID	Database identifier
ID	Table identifier
USER ID	User who created table
COLCOUNT	Column count

V$COLUMNS

Displays column information of Virtual Tables.

Column Name	Description
NAME	Column name
TYPE	Column data type
DATABASE_ID	Database identifier
ID	Column identifier
LENGTH	Column size
TABLE_ID	Table identifier
FLAG	Private data
PART_PAGE_COUNT	Unused
PAGE_VALUE_COUNT	Unused
MINMAX_CACHE_SIZE	Unused
MAX_CACHE_PART_COUNT	Unused

V$RETENTION_JOB

Displays table information to which RETENTION POLICY is applied.

Column Name	Description
USER_NAME	User name
TABLE_NAME	applied table name
POLICY_NAME	applied policy name
STATE	RETENTION state (RUNNING/WAITING/STOPPED)
LAST_DELETED_TIME	most recently deleted time

Last updated on Sep 27, 2023

Timezone