# 系统视图
GaussDB数据库兼容了部分Oracle数据库的系统视图，兼容的详细列表如下。
更多系统视图的字段说明信息请参见[系统视图](https://support.huaweicloud.com/distributed-ref-v10-gaussdb/gaussdb-08-1030.html)。
表1系统视图支持列表 
| 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               |