System Views

GaussDB is compatible with some Oracle system views, as shown in the following table.

For details about columns in system views, see "System Views" in Developer Guide.

**Table 1** Supported views
No.	Oracle	GaussDB
1	ALL_ALL_TABLES	DB_ALL_TABLES
2	ALL_COL_PRIVS	DB_COL_PRIVS
3	ALL_COLL_TYPES	DB_COLL_TYPES
4	ALL_ERRORS	DB_ERRORS
5	ALL_IND_COLUMNS	DB_IND_COLUMNS
6	ALL_COL_COMMENTS	DB_COL_COMMENTS
7	ALL_CONS_COLUMNS	DB_CONS_COLUMNS
8	ALL_CONSTRAINTS	DB_CONSTRAINTS
9	ALL_DEPENDENCIES	DB_DEPENDENCIES
10	ALL_DIRECTORIES	DB_DIRECTORIES
11	ALL_IND_EXPRESSIONS	DB_IND_EXPRESSIONS
12	ALL_IND_PARTITIONS	DB_IND_PARTITIONS
13	ALL_INDEXES	DB_INDEXES
14	ALL_IND_SUBPARTITIONS	DB_IND_SUBPARTITIONS
15	ALL_OBJECTS	DB_OBJECTS
16	ALL_PART_COL_STATISTICS	DB_PART_COL_STATISTICS
17	ALL_PART_KEY_COLUMNS	DB_PART_KEY_COLUMNS
18	ALL_PART_TABLES	DB_PART_TABLES
19	ALL_SCHEDULER_JOB_ARGS	DB_SCHEDULER_JOB_ARGS
20	ALL_SCHEDULER_PROGRAM_ARGS	DB_SCHEDULER_PROGRAM_ARGS
21	ALL_SEQUENCES	DB_SEQUENCES
22	ALL_SUBPART_COL_STATISTICS	DB_SUBPART_COL_STATISTICS
23	ALL_SUBPART_KEY_COLUMNS	DB_SUBPART_KEY_COLUMNS
24	ALL_SYNONYMS	DB_SYNONYMS
25	ALL_TAB_COL_STATISTICS	DB_TAB_COL_STATISTICS
26	ALL_TAB_COMMENTS	DB_TAB_COMMENTS
27	ALL_TAB_HISTOGRAMS	DB_TAB_HISTOGRAMS
28	ALL_TAB_STATS_HISTORY	DB_TAB_STATS_HISTORY
29	ALL_TYPES	DB_TYPES
30	ALL_PART_INDEXES	DB_PART_INDEXES
31	ALL_PROCEDURES	DB_PROCEDURES
32	ALL_SOURCE	DB_SOURCE
33	ALL_TAB_COLUMNS	DB_TAB_COLUMNS
34	ALL_TAB_PARTITIONS	DB_TAB_PARTITIONS
35	ALL_TAB_SUBPARTITIONS	DB_TAB_SUBPARTITIONS
36	ALL_TABLES	DB_TABLES
37	ALL_TRIGGERS	DB_TRIGGERS
38	ALL_USERS	DB_USERS
39	ALL_VIEWS	DB_VIEWS
40	DBA_AUDIT_OBJECT	ADM_AUDIT_OBJECT
41	DBA_AUDIT_SESSION	ADM_AUDIT_SESSION
42	DBA_AUDIT_STATEMENT	ADM_AUDIT_STATEMENT
43	DBA_AUDIT_TRAIL	ADM_AUDIT_TRAIL
44	DBA_COL_COMMENTS	ADM_COL_COMMENTS
45	DBA_COL_PRIVS	ADM_COL_PRIVS
46	DBA_COLL_TYPES	ADM_COLL_TYPES
47	DBA_ARGUMENTS	ADM_ARGUMENTS
48	DBA_CONSTRAINTS	ADM_CONSTRAINTS
49	DBA_DATA_FILES	ADM_DATA_FILES
50	DBA_CONS_COLUMNS	ADM_CONS_COLUMNS
51	DBA_DEPENDENCIES	ADM_DEPENDENCIES
52	DBA_DIRECTORIES	ADM_DIRECTORIES
53	DBA_PART_COL_STATISTICS	ADM_PART_COL_STATISTICS
54	DBA_PART_TABLES	ADM_PART_TABLES
55	DBA_RECYCLEBIN	ADM_RECYCLEBIN
56	DBA_ROLE_PRIVS	ADM_ROLE_PRIVS
57	DBA_ROLES	ADM_ROLES
58	DBA_SCHEDULER_JOB_ARGS	ADM_SCHEDULER_JOB_ARGS
59	DBA_SCHEDULER_PROGRAMS	ADM_SCHEDULER_PROGRAMS
60	DBA_SCHEDULER_PROGRAM_ARGS	ADM_SCHEDULER_PROGRAM_ARGS
61	DBA_HIST_SNAPSHOT	ADM_HIST_SNAPSHOT
62	DBA_HIST_SQL_PLAN	ADM_HIST_SQL_PLAN
63	DBA_HIST_SQLSTAT	ADM_HIST_SQLSTAT
64	DBA_HIST_SQLTEXT	ADM_HIST_SQLTEXT
65	DBA_ILMDATAMOVEMENTPOLICIES	GS_ADM_ILMDATAMOVEMENTPOLICIES
66	DBA_ILMEVALUATIONDETAILS	GS_ADM_ILMEVALUATIONDETAILS
67	DBA_ILMOBJECTS	GS_ADM_ILMOBJECTS
68	DBA_ILMPARAMETERS	GS_ADM_ILMPARAMETERS
69	DBA_ILMPOLICIES	GS_ADM_ILMPOLICIES
70	DBA_ILMRESULTS	GS_ADM_ILMRESULTS
71	DBA_ILMTASKS	GS_ADM_ILMTASKS
72	DBA_IND_COLUMNS	ADM_IND_COLUMNS
73	DBA_IND_EXPRESSIONS	ADM_IND_EXPRESSIONS
74	DBA_IND_PARTITIONS	ADM_IND_PARTITIONS
75	DBA_INDEXES	ADM_INDEXES
76	DBA_OBJECTS	ADM_OBJECTS
77	DBA_PART_INDEXES	ADM_PART_INDEXES
78	DBA_PROCEDURES	ADM_PROCEDURES
79	DBA_SCHEDULER_JOBS	ADM_SCHEDULER_JOBS
80	DBA_SCHEDULER_RUNNING_JOBS	ADM_SCHEDULER_RUNNING_JOBS
81	DBA_SEGMENTS	ADM_SEGMENTS
82	DBA_SEQUENCES	ADM_SEQUENCES
83	DBA_SOURCE	ADM_SOURCE
84	DBA_IND_SUBPARTITIONS	ADM_IND_SUBPARTITIONS
85	DBA_SUBPART_COL_STATISTICS	ADM_SUBPART_COL_STATISTICS
86	DBA_SUBPART_KEY_COLUMNS	ADM_SUBPART_KEY_COLUMNS
87	DBA_SYS_PRIVS	ADM_SYS_PRIVS
88	DBA_TAB_COL_STATISTICS	ADM_TAB_COL_STATISTICS
89	DBA_TAB_HISTOGRAMS	ADM_TAB_HISTOGRAMS
90	DBA_TAB_STATISTICS	ADM_TAB_STATISTICS
91	DBA_TAB_STATS_HISTORY	ADM_TAB_STATS_HISTORY
92	DBA_TABLESPACES	ADM_TABLESPACES
93	DBA_TYPES	ADM_TYPES
94	DBA_USERS	ADM_USERS
95	DBA_SYNONYMS	ADM_SYNONYMS
96	DBA_TAB_COLS	ADM_TAB_COLS
97	DBA_TAB_COLUMNS	ADM_TAB_COLUMNS
98	DBA_TAB_COMMENTS	ADM_TAB_COMMENTS
99	DBA_TABLES	ADM_TABLES
100	DBA_TAB_PARTITIONS	ADM_TAB_PARTITIONS
101	DBA_TAB_SUBPARTITIONS	ADM_TAB_SUBPARTITIONS
102	DBA_TRIGGERS	ADM_TRIGGERS
103	DBA_TYPE_ATTRS	ADM_TYPE_ATTRS
104	DBA_VIEWS	ADM_VIEWS
105	ROLE_ROLE_PRIVS	ROLE_ROLE_PRIVS
106	ROLE_SYS_PRIVS	ROLE_SYS_PRIVS
107	ROLE_TAB_PRIVS	ROLE_TAB_PRIVS
108	USER_COL_COMMENTS	MY_COL_COMMENTS
109	USER_COL_PRIVS	MY_COL_PRIVS
110	USER_COLL_TYPES	MY_COLL_TYPES
111	USER_CONSTRAINTS	MY_CONSTRAINTS
112	USER_DEPENDENCIES	MY_DEPENDENCIES
113	DICT	DICT
114	DICTIONARY	DICTIONARY
115	DUAL	DUAL
116	NLS_DATABASE_PARAMETERS	NLS_DATABASE_PARAMETERS
117	NLS_INSTANCE_PARAMETERS	NLS_INSTANCE_PARAMETERS
118	PLAN_TABLE	PLAN_TABLE
119	USER_ERRORS	MY_ERRORS
120	USER_ILMDATAMOVEMENTPOLICIES	GS_MY_ILMDATAMOVEMENTPOLICIES
121	USER_ILMEVALUATIONDETAILS	GS_MY_ILMEVALUATIONDETAILS
122	USER_ILMOBJECTS	GS_MY_ILMOBJECTS
123	USER_ILMPOLICIES	GS_MY_ILMPOLICIES
124	USER_ILMRESULTS	GS_MY_ILMRESULTS
125	USER_ILMTASKS	GS_MY_ILMTASKS
126	USER_IND_COLUMNS	MY_IND_COLUMNS
127	USER_IND_EXPRESSIONS	MY_IND_EXPRESSIONS
128	USER_IND_PARTITIONS	MY_IND_PARTITIONS
129	USER_IND_SUBPARTITIONS	MY_IND_SUBPARTITIONS
130	USER_INDEXES	MY_INDEXES
131	USER_JOBS	MY_JOBS
132	USER_OBJECTS	MY_OBJECTS
133	USER_PART_COL_STATISTICS	MY_PART_COL_STATISTICS
134	USER_PART_INDEXES	MY_PART_INDEXES
135	USER_PART_TABLES	MY_PART_TABLES
136	USER_PROCEDURES	MY_PROCEDURES
137	USER_RECYCLEBIN	MY_RECYCLEBIN
138	USER_SCHEDULER_JOB_ARGS	MY_SCHEDULER_JOB_ARGS
139	USER_SCHEDULER_PROGRAM_ARGS	MY_SCHEDULER_PROGRAM_ARGS
140	USER_SEQUENCES	MY_SEQUENCES
141	USER_SOURCE	MY_SOURCE
142	USER_SUBPART_KEY_COLUMNS	MY_SUBPART_KEY_COLUMNS
143	USER_SYNONYMS	MY_SYNONYMS
144	USER_SYS_PRIVS	MY_SYS_PRIVS
145	USER_TAB_COL_STATISTICS	MY_TAB_COL_STATISTICS
146	USER_TAB_COLUMNS	MY_TAB_COLUMNS
147	USER_TAB_COMMENTS	MY_TAB_COMMENTS
148	USER_TAB_HISTOGRAMS	MY_TAB_HISTOGRAMS
149	USER_TAB_PARTITIONS	MY_TAB_PARTITIONS
150	USER_TAB_STATISTICS	MY_TAB_STATISTICS
151	USER_TAB_STATS_HISTORY	MY_TAB_STATS_HISTORY
152	USER_TAB_SUBPARTITIONS	MY_TAB_SUBPARTITIONS
153	USER_TABLES	MY_TABLES
154	USER_TABLESPACES	MY_TABLESPACES
155	USER_TRIGGERS	MY_TRIGGERS
156	USER_TYPE_ATTRS	MY_TYPE_ATTRS
157	USER_TYPES	MY_TYPES
158	USER_VIEWS	MY_VIEWS
159	V$GLOBAL_TRANSACTION	V$GLOBAL_TRANSACTION
160	V$NLS_PARAMETERS	V$NLS_PARAMETERS
161	V$SESSION_WAIT	V$SESSION_WAIT
162	V$SYSSTAT	V$SYSSTAT
163	V$SYSTEM_EVENT	V$SYSTEM_EVENT
164	V$VERSION	V$VERSION
165	V$INSTANCE	V_INSTANCE
166	GV$INSTANCE	GV_INSTANCE
167	V$MYSTAT	V_MYSTAT
168	V$SESSION	V_SESSION
169	GV$SESSION	GV_SESSION
170	V$SESSION_LONGOPS	DV_SESSION_LONGOPS
171	V$SESSION	DV_SESSIONS
172	ALL_ARGUMENTS	DB_ARGUMENTS
173	USER_CONS_COLUMNS	MY_CONS_COLUMNS
174	USER_PART_KEY_COLUMNS	MY_PART_KEY_COLUMNS
175	USER_SUBPART_COL_STATISTICS	MY_SUBPART_COL_STATISTICS
176	USER_ROLE_PRIVS	MY_ROLE_PRIVS
177	DBA_TAB_PRIVS	ADM_TAB_PRIVS
178	USER_SCHEDULER_JOBS	MY_SCHEDULER_JOBS
179	V$LOCK	V$LOCK
180	V$DBLINK	V$DBLINK
181	V$OPEN_CURSOR	V$OPEN_CURSOR
182	ALL_TAB_PRIVS	DB_TAB_PRIVS
183	ALL_TAB_MODIFICATIONS	DB_TAB_MODIFICATIONS
184	USER_TAB_MODIFICATIONS	MY_TAB_MODIFICATIONS
185	USER_AUDIT_TRAIL	MY_AUDIT_TRAIL