系统视图
GaussDB数据库兼容了部分Oracle数据库的系统视图，兼容的详细列表如下。
更多系统视图的字段说明信息请参见系统视图。
| Oracle数据库 | GaussDB数据库 |
|---|---|
| ALL_ALL_TABLES | DB_ALL_TABLES |
| ALL_COL_PRIVS | DB_COL_PRIVS |
| ALL_COLL_TYPES | DB_COLL_TYPES |
| ALL_IND_COLUMNS | DB_IND_COLUMNS |
| ALL_COL_COMMENTS | DB_COL_COMMENTS |
| ALL_CONS_COLUMNS | DB_CONS_COLUMNS |
| ALL_CONSTRAINTS | DB_CONSTRAINTS |
| ALL_DEPENDENCIES | DB_DEPENDENCIES |
| ALL_DIRECTORIES | DB_DIRECTORIES |
| ALL_IND_EXPRESSIONS | DB_IND_EXPRESSIONS |
| ALL_IND_PARTITIONS | DB_IND_PARTITIONS |
| ALL_INDEXES | DB_INDEXES |
| ALL_IND_SUBPARTITIONS | DB_IND_SUBPARTITIONS |
| ALL_OBJECTS | DB_OBJECTS |
| ALL_PART_COL_STATISTICS | DB_PART_COL_STATISTICS |
| ALL_PART_KEY_COLUMNS | DB_PART_KEY_COLUMNS |
| ALL_PART_TABLES | DB_PART_TABLES |
| ALL_SCHEDULER_JOB_ARGS | DB_SCHEDULER_JOB_ARGS |
| ALL_SCHEDULER_PROGRAM_ARGS | DB_SCHEDULER_PROGRAM_ARGS |
| ALL_SEQUENCES | DB_SEQUENCES |
| ALL_SUBPART_KEY_COLUMNS | DB_SUBPART_KEY_COLUMNS |
| ALL_SYNONYMS | DB_SYNONYMS |
| ALL_TAB_COL_STATISTICS | DB_TAB_COL_STATISTICS |
| ALL_TAB_COMMENTS | DB_TAB_COMMENTS |
| ALL_TAB_HISTOGRAMS | DB_TAB_HISTOGRAMS |
| ALL_TAB_STATS_HISTORY | DB_TAB_STATS_HISTORY |
| ALL_TYPES | DB_TYPES |
| ALL_PROCEDURES | DB_PROCEDURES |
| ALL_SOURCE | DB_SOURCE |
| ALL_TAB_COLUMNS | DB_TAB_COLUMNS |
| ALL_TAB_PARTITIONS | DB_TAB_PARTITIONS |
| ALL_TAB_SUBPARTITIONS | DB_TAB_SUBPARTITIONS |
| ALL_TABLES | DB_TABLES |
| ALL_TRIGGERS | DB_TRIGGERS |
| ALL_USERS | DB_USERS |
| ALL_VIEWS | DB_VIEWS |
| DBA_AUDIT_OBJECT | ADM_AUDIT_OBJECT |
| DBA_AUDIT_SESSION | ADM_AUDIT_SESSION |
| DBA_AUDIT_STATEMENT | ADM_AUDIT_STATEMENT |
| DBA_AUDIT_TRAIL | ADM_AUDIT_TRAIL |
| DBA_COL_COMMENTS | ADM_COL_COMMENTS |
| DBA_COL_PRIVS | ADM_COL_PRIVS |
| DBA_COLL_TYPES | ADM_COLL_TYPES |
| DBA_ARGUMENTS | ADM_ARGUMENTS |
| DBA_CONSTRAINTS | ADM_CONSTRAINTS |
| DBA_DATA_FILES | ADM_DATA_FILES |
| DBA_CONS_COLUMNS | ADM_CONS_COLUMNS |
| DBA_DEPENDENCIES | ADM_DEPENDENCIES |
| DBA_DIRECTORIES | ADM_DIRECTORIES |
| DBA_PART_COL_STATISTICS | ADM_PART_COL_STATISTICS |
| DBA_PART_TABLES | ADM_PART_TABLES |
| DBA_ROLE_PRIVS | ADM_ROLE_PRIVS |
| DBA_ROLES | ADM_ROLES |
| DBA_SCHEDULER_JOB_ARGS | ADM_SCHEDULER_JOB_ARGS |
| DBA_SCHEDULER_PROGRAMS | ADM_SCHEDULER_PROGRAMS |
| DBA_SCHEDULER_PROGRAM_ARGS | ADM_SCHEDULER_PROGRAM_ARGS |
| DBA_HIST_SNAPSHOT | ADM_HIST_SNAPSHOT |
| DBA_HIST_SQL_PLAN | ADM_HIST_SQL_PLAN |
| DBA_HIST_SQLSTAT | ADM_HIST_SQLSTAT |
| DBA_HIST_SQLTEXT | ADM_HIST_SQLTEXT |
| DBA_ILMDATAMOVEMENTPOLICIES | GS_ADM_ILMDATAMOVEMENTPOLICIES |
| DBA_ILMEVALUATIONDETAILS | GS_ADM_ILMEVALUATIONDETAILS |
| DBA_ILMOBJECTS | GS_ADM_ILMOBJECTS |
| DBA_ILMPARAMETERS | GS_ADM_ILMPARAMETERS |
| DBA_ILMPOLICIES | GS_ADM_ILMPOLICIES |
| DBA_ILMRESULTS | GS_ADM_ILMRESULTS |
| DBA_ILMTASKS | GS_ADM_ILMTASKS |
| DBA_IND_COLUMNS | ADM_IND_COLUMNS |
| DBA_IND_EXPRESSIONS | ADM_IND_EXPRESSIONS |
| DBA_IND_PARTITIONS | ADM_IND_PARTITIONS |
| DBA_INDEXES | ADM_INDEXES |
| DBA_OBJECTS | ADM_OBJECTS |
| DBA_PART_INDEXES | ADM_PART_INDEXES |
| DBA_PROCEDURES | ADM_PROCEDURES |
| DBA_SCHEDULER_JOBS | ADM_SCHEDULER_JOBS |
| DBA_SCHEDULER_RUNNING_JOBS | ADM_SCHEDULER_RUNNING_JOBS |
| DBA_SEGMENTS | ADM_SEGMENTS |
| DBA_SEQUENCES | ADM_SEQUENCES |
| DBA_SOURCE | ADM_SOURCE |
| DBA_IND_SUBPARTITIONS | ADM_IND_SUBPARTITIONS |
| DBA_SUBPART_KEY_COLUMNS | ADM_SUBPART_KEY_COLUMNS |
| DBA_SYS_PRIVS | ADM_SYS_PRIVS |
| DBA_TAB_COL_STATISTICS | ADM_TAB_COL_STATISTICS |
| DBA_TAB_HISTOGRAMS | ADM_TAB_HISTOGRAMS |
| DBA_TAB_STATISTICS | ADM_TAB_STATISTICS |
| DBA_TAB_STATS_HISTORY | ADM_TAB_STATS_HISTORY |
| DBA_TABLESPACES | ADM_TABLESPACES |
| DBA_TYPES | ADM_TYPES |
| DBA_USERS | ADM_USERS |
| DBA_SYNONYMS | ADM_SYNONYMS |
| DBA_TAB_COLS | ADM_TAB_COLS |
| DBA_TAB_COLUMNS | ADM_TAB_COLUMNS |
| DBA_TAB_COMMENTS | ADM_TAB_COMMENTS |
| DBA_TABLES | ADM_TABLES |
| DBA_TAB_PARTITIONS | ADM_TAB_PARTITIONS |
| DBA_TAB_SUBPARTITIONS | ADM_TAB_SUBPARTITIONS |
| DBA_TRIGGERS | ADM_TRIGGERS |
| DBA_TYPE_ATTRS | ADM_TYPE_ATTRS |
| DBA_VIEWS | ADM_VIEWS |
| ROLE_ROLE_PRIVS | ROLE_ROLE_PRIVS |
| ROLE_SYS_PRIVS | ROLE_SYS_PRIVS |
| ROLE_TAB_PRIVS | ROLE_TAB_PRIVS |
| USER_COL_COMMENTS | MY_COL_COMMENTS |
| USER_COL_PRIVS | MY_COL_PRIVS |
| USER_COLL_TYPES | MY_COLL_TYPES |
| USER_CONSTRAINTS | MY_CONSTRAINTS |
| USER_DEPENDENCIES | MY_DEPENDENCIES |
| DICT | DICT |
| DICTIONARY | DICTIONARY |
| DUAL | DUAL |
| NLS_DATABASE_PARAMETERS | NLS_DATABASE_PARAMETERS |
| NLS_INSTANCE_PARAMETERS | NLS_INSTANCE_PARAMETERS |
| PLAN_TABLE | PLAN_TABLE |
| USER_ILMDATAMOVEMENTPOLICIES | GS_MY_ILMDATAMOVEMENTPOLICIES |
| USER_ILMEVALUATIONDETAILS | GS_MY_ILMEVALUATIONDETAILS |
| USER_ILMOBJECTS | GS_MY_ILMOBJECTS |
| USER_ILMPOLICIES | GS_MY_ILMPOLICIES |
| USER_ILMRESULTS | GS_MY_ILMRESULTS |
| USER_ILMTASKS | GS_MY_ILMTASKS |
| USER_IND_COLUMNS | MY_IND_COLUMNS |
| USER_IND_EXPRESSIONS | MY_IND_EXPRESSIONS |
| USER_IND_PARTITIONS | MY_IND_PARTITIONS |
| USER_IND_SUBPARTITIONS | MY_IND_SUBPARTITIONS |
| USER_INDEXES | MY_INDEXES |
| USER_JOBS | MY_JOBS |
| USER_OBJECTS | MY_OBJECTS |
| USER_PART_COL_STATISTICS | MY_PART_COL_STATISTICS |
| USER_PART_INDEXES | MY_PART_INDEXES |
| USER_PART_TABLES | MY_PART_TABLES |
| USER_PROCEDURES | MY_PROCEDURES |
| USER_SCHEDULER_JOB_ARGS | MY_SCHEDULER_JOB_ARGS |
| USER_SCHEDULER_PROGRAM_ARGS | MY_SCHEDULER_PROGRAM_ARGS |
| USER_SEQUENCES | MY_SEQUENCES |
| USER_SOURCE | MY_SOURCE |
| USER_SUBPART_KEY_COLUMNS | MY_SUBPART_KEY_COLUMNS |
| USER_SYNONYMS | MY_SYNONYMS |
| USER_SYS_PRIVS | MY_SYS_PRIVS |
| USER_TAB_COL_STATISTICS | MY_TAB_COL_STATISTICS |
| USER_TAB_COLUMNS | MY_TAB_COLUMNS |
| USER_TAB_COMMENTS | MY_TAB_COMMENTS |
| USER_TAB_HISTOGRAMS | MY_TAB_HISTOGRAMS |
| USER_TAB_PARTITIONS | MY_TAB_PARTITIONS |
| USER_TAB_STATISTICS | MY_TAB_STATISTICS |
| USER_TAB_STATS_HISTORY | MY_TAB_STATS_HISTORY |
| USER_TABLES | MY_TABLES |
| USER_TABLESPACES | MY_TABLESPACES |
| USER_TRIGGERS | MY_TRIGGERS |
| USER_TYPE_ATTRS | MY_TYPE_ATTRS |
| USER_TYPES | MY_TYPES |
| USER_VIEWS | MY_VIEWS |
| V$NLS_PARAMETERS | V$NLS_PARAMETERS |
| V$SESSION_WAIT | V$SESSION_WAIT |
| V$SYSSTAT | V$SYSSTAT |
| V$SYSTEM_EVENT | V$SYSTEM_EVENT |
| V$VERSION | V$VERSION |
| V$INSTANCE | V_INSTANCE |
| GV$INSTANCE | GV_INSTANCE |
| V$MYSTAT | V_MYSTAT |
| V$SESSION | V_SESSION |
| GV$SESSION | GV_SESSION |
| V$SESSION_LONGOPS | DV_SESSION_LONGOPS |
| V$SESSION | DV_SESSIONS |
| ALL_ARGUMENTS | DB_ARGUMENTS |
| USER_CONS_COLUMNS | MY_CONS_COLUMNS |
| USER_PART_KEY_COLUMNS | MY_PART_KEY_COLUMNS |
| USER_ROLE_PRIVS | MY_ROLE_PRIVS |
| DBA_TAB_PRIVS | ADM_TAB_PRIVS |
| USER_SCHEDULER_JOBS | MY_SCHEDULER_JOBS |
| V$LOCK | V$LOCK |
| V$DBLINK | V$DBLINK |
| V$GLOBAL_TRANSACTION | V$GLOBAL_TRANSACTION |
| V$OPEN_CURSOR | V$OPEN_CURSOR |
| V$GLOBAL_OPEN_CURSOR | V$GLOBAL_OPEN_CURSOR |
| ALL_TAB_PRIVS | DB_TAB_PRIVS |
| ALL_TAB_MODIFICATIONS | DB_TAB_MODIFICATIONS |
| USER_TAB_MODIFICATIONS | MY_TAB_MODIFICATIONS |
| USER_AUDIT_TRAIL | MY_AUDIT_TRAIL |
