System Views

GaussDB is compatible with some Oracle Database system views. For details, see the following table.

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

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