# 系统视图
GaussDB数据库兼容了部分Oracle数据库的系统视图，兼容的详细列表如[表1]所示，更多系统视图的字段说明信息请参见[系统视图](https://support.huaweicloud.com/centralized-ref-v10-gaussdb/gaussdb-38-1276.html)。
 表1支持视图列表 
| Oracle数据库                   | GaussDB数据库                    |
|:---|:---|
| ALL_ALL_TABLES                | DB_ALL_TABLES                 |
| ALL_COL_PRIVS                 | DB_COL_PRIVS                   |
| ALL_COLL_TYPES               | DB_COLL_TYPES                  |
| ALL_ERRORS                     | DB_ERRORS                    |
| 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_COL_STATISTICS      | DB_SUBPART_COL_STATISTICS      |
| 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_PART_INDEXES                | DB_PART_INDEXES                  |
| 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_RECYCLEBIN               | ADM_RECYCLEBIN                  |
| 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_COL_STATISTICS     | ADM_SUBPART_COL_STATISTICS    |
| 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_ERRORS                   | MY_ERRORS                     |
| 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_RECYCLEBIN               | MY_RECYCLEBIN                 |
| 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_TAB_SUBPARTITIONS          | MY_TAB_SUBPARTITIONS           |
| 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$GLOBAL_TRANSACTION         | V$GLOBAL_TRANSACTION          |
| 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_SUBPART_COL_STATISTICS   | MY_SUBPART_COL_STATISTICS      |
| 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$OPEN_CURSOR                | V$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               |
   
