System Views

• ALL_ALL_TABLES

• ALL_CONSTRAINTS

• ALL_CONS_COLUMNS

• ALL_COL_COMMENTS

• ALL_DEPENDENCIES

• ALL_IND_COLUMNS

• ALL_IND_EXPRESSIONS

• ALL_INDEXES

• ALL_OBJECTS

• ALL_PROCEDURES

• ALL_SEQUENCES

• ALL_SOURCE

• ALL_SYNONYMS

• ALL_TAB_COLUMNS

• ALL_TAB_COMMENTS

• ALL_TABLES

• ALL_USERS

• ALL_VIEWS

• DBA_DATA_FILES

• DBA_USERS

• DBA_COL_COMMENTS

• DBA_CONSTRAINTS

• DBA_CONS_COLUMNS

• DBA_IND_COLUMNS

• DBA_IND_EXPRESSIONS

• DBA_IND_PARTITIONS

• DBA_INDEXES

• DBA_OBJECTS

• DBA_PART_INDEXES

• DBA_PART_TABLES

• DBA_PROCEDURES

• DBA_SEQUENCES

• DBA_SOURCE

• DBA_SYNONYMS

• DBA_TAB_COLUMNS

• DBA_TAB_COMMENTS

• DBA_TAB_PARTITIONS

• DBA_TABLES

• DBA_TABLESPACES

• DBA_TRIGGERS

• DBA_VIEWS

• DUAL

• GET_ALL_TSC_INFO

• GET_TSC_INFO

• GLOBAL_COLUMN_TABLE_IO_STAT

• GLOBAL_REDO_STAT

• GLOBAL_REL_IOSTAT

• GLOBAL_ROW_TABLE_IO_STAT

• GLOBAL_STAT_DATABASE

• GLOBAL_TABLE_CHANGE_STAT

• GLOBAL_TABLE_STAT

• GLOBAL_WORKLOAD_SQL_COUNT

• GLOBAL_WORKLOAD_SQL_ELAPSE_TIME

• GLOBAL_WORKLOAD_TRANSACTION

• GS_ALL_CONTROL_GROUP_INFO

• GS_BLOCKLIST_QUERY

• GS_CLUSTER_RESOURCE_INFO

• GS_COLUMN_TABLE_IO_STAT

• GS_OBS_READ_TRAFFIC

• GS_OBS_WRITE_TRAFFIC

• GS_INSTR_UNIQUE_SQL

• GS_NODE_STAT_RESET_TIME

• GS_OBS_LATENCY

• GS_QUERY_MONITOR

• GS_REL_IOSTAT

• GS_RESPOOL_RUNTIME_INFO

• GS_RESPOOL_RESOURCE_INFO

• GS_RESPOOL_MONITOR

• GS_ROW_TABLE_IO_STAT

• GS_SESSION_CPU_STATISTICS

• GS_SESSION_MEMORY_STATISTICS

• GS_SQL_COUNT

• GS_STAT_DB_CU

• GS_STAT_SESSION_CU

• GS_TABLE_CHANGE_STAT

• GS_TABLE_STAT

• GS_TOTAL_NODEGROUP_MEMORY_DETAIL

• GS_USER_MONITOR

• GS_USER_TRANSACTION

• GS_VIEW_DEPENDENCY

• GS_VIEW_DEPENDENCY_PATH

• GS_VIEW_INVALID

• GS_WAIT_EVENTS

• GS_WLM_OPERAROR_INFO

• GS_WLM_OPERATOR_HISTORY

• GS_WLM_OPERATOR_STATISTICS

• GS_WLM_SESSION_INFO

• GS_WLM_SESSION_HISTORY

• GS_WLM_SESSION_STATISTICS

• GS_WLM_SQL_ALLOW

• GS_WORKLOAD_SQL_COUNT

• GS_WORKLOAD_SQL_ELAPSE_TIME

• GS_WORKLOAD_TRANSACTION

• MPP_TABLES

• PG_AVAILABLE_EXTENSION_VERSIONS

• PG_AVAILABLE_EXTENSIONS

• PG_BULKLOAD_STATISTICS

• PG_COMM_CLIENT_INFO

• PG_COMM_DELAY

• PG_COMM_STATUS

• PG_COMM_RECV_STREAM

• PG_COMM_SEND_STREAM

• PG_COMM_QUERY_SPEED

• PG_CONTROL_GROUP_CONFIG

• PG_CURSORS

• PG_EXT_STATS

• PG_GET_INVALID_BACKENDS

• PG_GET_SENDERS_CATCHUP_TIME

• PG_GROUP

• PG_INDEXES

• PG_JOB

• PG_JOB_PROC

• PG_JOB_SINGLE

• PG_LIFECYCLE_DATA_DISTRIBUTE

• PG_LOCKS

• PG_NODE_ENV

• PG_OS_THREADS

• PG_POOLER_STATUS

• PG_PREPARED_STATEMENTS

• PG_PREPARED_XACTS

• PG_PUBLICATION_TABLES

• PG_QUERYBAND_ACTION

• PG_REPLICATION_SLOTS

• PG_ROLES

• PG_RULES

• PG_RUNNING_XACTS

• PG_SECLABELS

• PG_SESSION_WLMSTAT

• PG_SESSION_IOSTAT

• PG_SETTINGS

• PG_SHADOW

• PG_SHARED_MEMORY_DETAIL

• PG_STATS

• PG_STAT_ACTIVITY

• PG_STAT_ALL_INDEXES

• PG_STAT_ALL_TABLES

• PG_STAT_BAD_BLOCK

• PG_STAT_BGWRITER

• PG_STAT_DATABASE

• PG_STAT_DATABASE_CONFLICTS

• PG_STAT_GET_MEM_MBYTES_RESERVED

• PG_STAT_USER_FUNCTIONS

• PG_STAT_USER_INDEXES

• PG_STAT_USER_TABLES

• PG_STAT_REPLICATION

• PG_STAT_SYS_INDEXES

• PG_STAT_SYS_TABLES

• PG_STAT_XACT_ALL_TABLES

• PG_STAT_XACT_SYS_TABLES

• PG_STAT_XACT_USER_FUNCTIONS

• PG_STAT_XACT_USER_TABLES

• PG_STATIO_ALL_INDEXES

• PG_STATIO_ALL_SEQUENCES

• PG_STATIO_ALL_TABLES

• PG_STATIO_SYS_INDEXES

• PG_STATIO_SYS_SEQUENCES

• PG_STATIO_SYS_TABLES

• PG_STATIO_USER_INDEXES

• PG_STATIO_USER_SEQUENCES

• PG_STATIO_USER_TABLES

• PG_THREAD_WAIT_STATUS

• PG_TABLES

• PG_TDE_INFO

• PG_TIMEZONE_ABBREVS

• PG_TIMEZONE_NAMES

• PG_TOTAL_MEMORY_DETAIL

• PG_TOTAL_SCHEMA_INFO

• PG_TOTAL_USER_RESOURCE_INFO

• PG_USER

• PG_USER_MAPPINGS

• PG_VIEWS

• PG_WLM_STATISTICS

• PGXC_BULKLOAD_PROGRESS

• PGXC_BULKLOAD_STATISTICS

• PGXC_COLUMN_TABLE_IO_STAT

• PGXC_COMM_CLIENT_INFO

• PGXC_COMM_DELAY

• PGXC_COMM_RECV_STREAM

• PGXC_COMM_SEND_STREAM

• PGXC_COMM_STATUS

• PGXC_COMM_QUERY_SPEED

• PGXC_DEADLOCK

• PGXC_GET_STAT_ALL_TABLES

• PGXC_GET_STAT_ALL_PARTITIONS

• PGXC_GET_TABLE_SKEWNESS

• PGXC_WLM_TABLE_DISTRIBUTION_SKEWNESS

• PGXC_GTM_SNAPSHOT_STATUS

• PGXC_INSTANCE_TIME

• PGXC_LOCKWAIT_DETAIL

• PGXC_INSTR_UNIQUE_SQL

• PGXC_LOCK_CONFLICTS

• PGXC_NODE_ENV

• PGXC_NODE_STAT_RESET_TIME

• PGXC_OS_RUN_INFO

• PGXC_OS_THREADS

• PGXC_POOLER_STATUS

• PGXC_PREPARED_XACTS

• PGXC_REDO_STAT

• PGXC_REL_IOSTAT

• PGXC_REPLICATION_SLOTS

• PGXC_RESPOOL_RUNTIME_INFO

• PGXC_RESPOOL_RESOURCE_INFO

• PGXC_RESPOOL_RESOURCE_HISTORY

• PGXC_ROW_TABLE_IO_STAT

• PGXC_RUNNING_XACTS

• PGXC_SETTINGS

• PGXC_SESSION_WLMSTAT

• PGXC_STAT_ACTIVITY

• PGXC_STAT_BAD_BLOCK

• PGXC_STAT_BGWRITER

• PGXC_STAT_DATABASE

• PGXC_STAT_OBJECT

• PGXC_STAT_REPLICATION

• PGXC_STAT_TABLE_DIRTY

• PGXC_STAT_WAL

• PGXC_SQL_COUNT

• PGXC_TABLE_CHANGE_STAT

• PGXC_TABLE_STAT

• PGXC_THREAD_WAIT_STATUS

• PGXC_TOTAL_MEMORY_DETAIL

• PGXC_TOTAL_SCHEMA_INFO

• PGXC_TOTAL_SCHEMA_INFO_ANALYZE

• PGXC_TOTAL_USER_RESOURCE_INFO

• PGXC_USER_TRANSACTION

• PGXC_VARIABLE_INFO

• PGXC_WAIT_DETAIL

• PGXC_WAIT_EVENTS

• PGXC_WLM_OPERATOR_HISTORY

• PGXC_WLM_OPERATOR_INFO

• PGXC_WLM_OPERATOR_STATISTICS

• PGXC_WLM_SESSION_INFO

• PGXC_WLM_SESSION_HISTORY

• PGXC_WLM_SESSION_STATISTICS

• PGXC_WLM_USER_RESOURCE_HISTORY

• PGXC_WLM_WORKLOAD_RECORDS

• PGXC_WORKLOAD_SQL_COUNT

• PGXC_WORKLOAD_SQL_ELAPSE_TIME

• PGXC_WORKLOAD_TRANSACTION

• PLAN_TABLE

• PV_FILE_STAT

• PV_INSTANCE_TIME

• PV_OS_RUN_INFO

• PV_SESSION_MEMORY

• PV_SESSION_MEMORY_DETAIL

• PV_SESSION_STAT

• PV_SESSION_TIME

• PV_TOTAL_MEMORY_DETAIL

• PV_REDO_STAT

• PV_RUNTIME_ATTSTATS

• PV_RUNTIME_RELSTATS

• REDACTION_COLUMNS

• REDACTION_POLICIES

• REMOTE_TABLE_STAT

• SHOW_TSC_INFO

• SHOW_ALL_TSC_INFO

• USER_COL_COMMENTS

• USER_CONSTRAINTS

• USER_CONS_COLUMNS

• USER_INDEXES

• USER_IND_COLUMNS

• USER_IND_EXPRESSIONS

• USER_IND_PARTITIONS

• USER_JOBS

• USER_OBJECTS

• USER_PART_INDEXES

• USER_PART_TABLES

• USER_PROCEDURES

• USER_SEQUENCES

• USER_SOURCE

• USER_SYNONYMS

• USER_TAB_COLUMNS

• USER_TAB_COMMENTS

• USER_TAB_PARTITIONS

• USER_TABLES

• USER_TRIGGERS

• USER_VIEWS

• V$SESSION

• V$SESSION_LONGOPS

last updated: 2024-12-11 14:09 UTC - commit: 68b0697a99ca2a4acec84bb31c0962598d3b4a14