Schemas

The DBE_PLDEVELOPER and SYS schemas are inherited. For details, see "Schemas" in Developer Guide. In addition, some views of the DBE_PERF and PG_CATALOG schemas are inherited and these views under these schemas are renamed with the prefix gs_. Table 1 lists the mapping. To ensure compatibility, preferentially use views whose alias prefixed with gs_.

**Table 1** Aliases of the system view in the M-compatible database
Schema	Original View Name	View Alias
DBE_PERF	ai_watchdog_detection_warnings	gs_ai_watchdog_detection_warnings
DBE_PERF	ai_watchdog_monitor_status	gs_ai_watchdog_monitor_status
DBE_PERF	ai_watchdog_parameters	gs_ai_watchdog_parameters
DBE_PERF	bgwriter_stat	gs_bgwriter_stat
DBE_PERF	class_vital_info	gs_class_vital_info
DBE_PERF	config_settings	gs_config_settings
DBE_PERF	file_iostat	gs_file_iostat
DBE_PERF	file_redo_iostat	gs_file_redo_iostat
DBE_PERF	global_bgwriter_stat	gs_global_bgwriter_stat
DBE_PERF	global_candidate_status	gs_global_candidate_status
DBE_PERF	global_ckpt_status	gs_global_ckpt_status
DBE_PERF	global_config_settings	gs_global_config_settings
DBE_PERF	global_double_write_status	gs_global_double_write_status
DBE_PERF	global_file_iostat	gs_global_file_iostat
DBE_PERF	global_file_redo_iostat	gs_global_file_redo_iostat
DBE_PERF	global_instance_time	gs_global_instance_time
DBE_PERF	global_locks	gs_global_locks
DBE_PERF	global_memory_node_detail	gs_global_memory_node_detail
DBE_PERF	global_operator_history	gs_global_operator_history
DBE_PERF	global_operator_history_table	gs_global_operator_history_table
DBE_PERF	global_operator_runtime	gs_global_operator_runtime
DBE_PERF	global_os_runtime	gs_global_os_runtime
DBE_PERF	global_os_threads	gs_global_os_threads
DBE_PERF	global_pagewriter_status	gs_global_pagewriter_status
DBE_PERF	global_parallel_decode_status	gs_global_parallel_decode_status
DBE_PERF	global_parallel_decode_thread_info	gs_global_parallel_decode_thread_info
DBE_PERF	global_plancache_clean	gs_global_plancache_clean
DBE_PERF	global_plancache_status	gs_global_plancache_status
DBE_PERF	global_record_reset_time	gs_global_record_reset_time
DBE_PERF	global_recovery_status	gs_global_recovery_status
DBE_PERF	global_redo_status	gs_global_redo_status
DBE_PERF	global_rel_iostat	gs_global_rel_iostat
DBE_PERF	global_replication_slots	gs_global_replication_slots
DBE_PERF	global_replication_stat	gs_global_replication_stat
DBE_PERF	global_rto_status	gs_global_rto_status
DBE_PERF	global_session_memory	gs_global_session_memory
DBE_PERF	global_session_memory_detail	gs_global_session_memory_detail
DBE_PERF	global_session_stat	gs_global_session_stat
DBE_PERF	global_session_stat_activity	gs_global_session_stat_activity
DBE_PERF	global_session_time	gs_global_session_time
DBE_PERF	global_shared_memory_detail	gs_global_shared_memory_detail
DBE_PERF	global_single_flush_dw_status	gs_global_single_flush_dw_status
DBE_PERF	global_slow_query_history	gs_global_slow_query_history
DBE_PERF	global_slow_query_info	gs_global_slow_query_info
DBE_PERF	global_stat_all_indexes	gs_global_stat_all_indexes
DBE_PERF	global_stat_all_tables	gs_global_stat_all_tables
DBE_PERF	global_stat_bad_block	gs_global_stat_bad_block
DBE_PERF	global_stat_database	gs_global_stat_database
DBE_PERF	global_stat_database_conflicts	gs_global_stat_database_conflicts
DBE_PERF	global_stat_db_cu	gs_global_stat_db_cu
DBE_PERF	global_stat_session_cu	gs_global_stat_session_cu
DBE_PERF	global_stat_sys_indexes	gs_global_stat_sys_indexes
DBE_PERF	global_stat_sys_tables	gs_global_stat_sys_tables
DBE_PERF	global_stat_user_functions	gs_global_stat_user_functions
DBE_PERF	global_stat_user_indexes	gs_global_stat_user_indexes
DBE_PERF	global_stat_user_tables	gs_global_stat_user_tables
DBE_PERF	global_stat_xact_all_tables	gs_global_stat_xact_all_tables
DBE_PERF	global_stat_xact_sys_tables	gs_global_stat_xact_sys_tables
DBE_PERF	global_stat_xact_user_functions	gs_global_stat_xact_user_functions
DBE_PERF	global_stat_xact_user_tables	gs_global_stat_xact_user_tables
DBE_PERF	global_statement_complex_history	gs_global_statement_complex_history
DBE_PERF	global_statement_complex_history_table	gs_global_statement_complex_history_table
DBE_PERF	global_statement_complex_runtime	gs_global_statement_complex_runtime
DBE_PERF	global_statement_count	gs_global_statement_count
DBE_PERF	global_statio_all_indexes	gs_global_statio_all_indexes
DBE_PERF	global_statio_all_sequences	gs_global_statio_all_sequences
DBE_PERF	global_statio_all_tables	gs_global_statio_all_tables
DBE_PERF	global_statio_sys_indexes	gs_global_statio_sys_indexes
DBE_PERF	global_statio_sys_sequences	gs_global_statio_sys_sequences
DBE_PERF	global_statio_sys_tables	gs_global_statio_sys_tables
DBE_PERF	global_statio_user_indexes	gs_global_statio_user_indexes
DBE_PERF	global_statio_user_sequences	gs_global_statio_user_sequences
DBE_PERF	global_statio_user_tables	gs_global_statio_user_tables
DBE_PERF	global_streaming_hadr_rto_and_rpo_stat	gs_global_streaming_hadr_rto_and_rpo_stat
DBE_PERF	global_thread_wait_status	gs_global_thread_wait_status
DBE_PERF	global_threadpool_status	gs_global_threadpool_status
DBE_PERF	global_transactions_prepared_xacts	gs_global_transactions_prepared_xacts
DBE_PERF	global_transactions_running_xacts	gs_global_transactions_running_xacts
DBE_PERF	global_user_transaction	gs_global_user_transaction
DBE_PERF	global_wait_events	gs_global_wait_events
DBE_PERF	global_workload_transaction	gs_global_workload_transaction
DBE_PERF	slow_query_history	gs_slow_query_history
DBE_PERF	slow_query_info	gs_slow_query_info
DBE_PERF	instance_time	gs_instance_time
DBE_PERF	local_rel_iostat	gs_local_rel_iostat
DBE_PERF	local_threadpool_status	gs_local_threadpool_status
DBE_PERF	locks	gs_locks
DBE_PERF	memory_node_detail	gs_memory_node_detail
DBE_PERF	node_name	gs_node_name
DBE_PERF	operator_history	gs_operator_history
DBE_PERF	operator_history_table	gs_operator_history_table
DBE_PERF	operator_runtime	gs_operator_runtime
DBE_PERF	os_runtime	gs_os_runtime
DBE_PERF	os_threads	gs_os_threads
DBE_PERF	parallel_decode_status	gs_parallel_decode_status
DBE_PERF	parallel_decode_thread_info	gs_parallel_decode_thread_info
DBE_PERF	replication_slots	gs_replication_slots
DBE_PERF	replication_stat	gs_replication_stat
DBE_PERF	session_cpu_runtime	gs_session_cpu_runtime
DBE_PERF	session_memory_detail	gs_session_memory_detail
DBE_PERF	session_memory_runtime	gs_session_memory_runtime
DBE_PERF	session_stat	gs_session_stat
DBE_PERF	session_stat_activity	gs_session_stat_activity
DBE_PERF	session_time	gs_session_time
DBE_PERF	shared_memory_detail	gs_shared_memory_detail
DBE_PERF	stat_all_indexes	gs_stat_all_indexes
DBE_PERF	stat_all_tables	gs_stat_all_tables
DBE_PERF	stat_bad_block	gs_stat_bad_block
DBE_PERF	stat_database	gs_stat_database
DBE_PERF	stat_database_conflicts	gs_stat_database_conflicts
DBE_PERF	stat_sys_indexes	gs_stat_sys_indexes
DBE_PERF	stat_sys_tables	gs_stat_sys_tables
DBE_PERF	stat_user_functions	gs_stat_user_functions
DBE_PERF	stat_user_indexes	gs_stat_user_indexes
DBE_PERF	stat_user_tables	gs_stat_user_tables
DBE_PERF	stat_xact_all_tables	gs_stat_xact_all_tables
DBE_PERF	stat_xact_sys_tables	gs_stat_xact_sys_tables
DBE_PERF	stat_xact_user_functions	gs_stat_xact_user_functions
DBE_PERF	stat_xact_user_tables	gs_stat_xact_user_tables
DBE_PERF	statement	gs_statement
DBE_PERF	statement_complex_history	gs_statement_complex_history
DBE_PERF	statement_complex_history_table	gs_statement_complex_history_table
DBE_PERF	statement_complex_runtime	gs_statement_complex_runtime
DBE_PERF	statement_count	gs_statement_count
DBE_PERF	statement_history	gs_statement_history
DBE_PERF	statement_iostat_complex_runtime	gs_statement_iostat_complex_runtime
DBE_PERF	statement_responsetime_percentile	gs_statement_responsetime_percentile
DBE_PERF	statement_wlmstat_complex_runtime	gs_statement_wlmstat_complex_runtime
DBE_PERF	statio_all_indexes	gs_statio_all_indexes
DBE_PERF	statio_all_sequences	gs_statio_all_sequences
DBE_PERF	statio_all_tables	gs_statio_all_tables
DBE_PERF	statio_sys_indexes	gs_statio_sys_indexes
DBE_PERF	statio_sys_sequences	gs_statio_sys_sequences
DBE_PERF	statio_sys_tables	gs_statio_sys_tables
DBE_PERF	statio_user_indexes	gs_statio_user_indexes
DBE_PERF	statio_user_sequences	gs_statio_user_sequences
DBE_PERF	statio_user_tables	gs_statio_user_tables
DBE_PERF	summary_file_iostat	gs_summary_file_iostat
DBE_PERF	summary_file_redo_iostat	gs_summary_file_redo_iostat
DBE_PERF	summary_rel_iostat	gs_summary_rel_iostat
DBE_PERF	summary_stat_all_indexes	gs_summary_stat_all_indexes
DBE_PERF	summary_stat_all_tables	gs_summary_stat_all_tables
DBE_PERF	summary_stat_bad_block	gs_summary_stat_bad_block
DBE_PERF	summary_stat_database	gs_summary_stat_database
DBE_PERF	summary_stat_database_conflicts	gs_summary_stat_database_conflicts
DBE_PERF	summary_stat_sys_indexes	gs_summary_stat_sys_indexes
DBE_PERF	summary_stat_sys_tables	gs_summary_stat_sys_tables
DBE_PERF	summary_stat_user_functions	gs_summary_stat_user_functions
DBE_PERF	summary_stat_user_indexes	gs_summary_stat_user_indexes
DBE_PERF	summary_stat_user_tables	gs_summary_stat_user_tables
DBE_PERF	summary_stat_xact_all_tables	gs_summary_stat_xact_all_tables
DBE_PERF	summary_stat_xact_sys_tables	gs_summary_stat_xact_sys_tables
DBE_PERF	summary_stat_xact_user_functions	gs_summary_stat_xact_user_functions
DBE_PERF	summary_stat_xact_user_tables	gs_summary_stat_xact_user_tables
DBE_PERF	summary_statement	gs_summary_statement
DBE_PERF	summary_statement_count	gs_summary_statement_count
DBE_PERF	summary_statio_all_indexes	gs_summary_statio_all_indexes
DBE_PERF	summary_statio_all_sequences	gs_summary_statio_all_sequences
DBE_PERF	summary_statio_all_tables	gs_summary_statio_all_tables
DBE_PERF	summary_statio_sys_indexes	gs_summary_statio_sys_indexes
DBE_PERF	summary_statio_sys_sequences	gs_summary_statio_sys_sequences
DBE_PERF	summary_statio_sys_tables	gs_summary_statio_sys_tables
DBE_PERF	summary_statio_user_indexes	gs_summary_statio_user_indexes
DBE_PERF	summary_statio_user_sequences	gs_summary_statio_user_sequences
DBE_PERF	summary_statio_user_tables	gs_summary_statio_user_tables
DBE_PERF	summary_transactions_prepared_xacts	gs_summary_transactions_prepared_xacts
DBE_PERF	summary_transactions_running_xacts	gs_summary_transactions_running_xacts
DBE_PERF	summary_user_login	gs_summary_user_login
DBE_PERF	summary_workload_sql_count	gs_summary_workload_sql_count
DBE_PERF	summary_workload_sql_elapse_time	gs_summary_workload_sql_elapse_time
DBE_PERF	summary_workload_transaction	gs_summary_workload_transaction
DBE_PERF	thread_wait_status	gs_thread_wait_status
DBE_PERF	transactions_prepared_xacts	gs_transactions_prepared_xacts
DBE_PERF	transactions_running_xacts	gs_transactions_running_xacts
DBE_PERF	user_login	gs_user_login
DBE_PERF	user_transaction	gs_user_transaction
DBE_PERF	wait_events	gs_wait_events
DBE_PERF	wlm_user_resource_config	gs_wlm_user_resource_config
DBE_PERF	wlm_user_resource_runtime	gs_wlm_user_resource_runtime
DBE_PERF	workload_sql_count	gs_workload_sql_count
DBE_PERF	workload_sql_elapse_time	gs_workload_sql_elapse_time
DBE_PERF	workload_transaction	gs_workload_transaction
DBE_PERF	global_adio_completer_status	gs_global_adio_completer_status
DBE_PERF	global_aio_slot_usage_status	gs_global_aio_slot_usage_status
DBE_PERF	ai_watchdog_ftask_status	gs_ai_watchdog_ftask_status
DBE_PERF	perf_query	gs_perf_query
PG_CATALOG	dv_sessions	gs_dv_sessions
PG_CATALOG	dv_session_longops	gs_dv_session_longops
PG_CATALOG	mpp_tables	gs_mpp_tables
PG_CATALOG	get_global_prepared_xacts	gs_get_global_prepared_xacts
PG_CATALOG	pgxc_prepared_xacts	gs_pgxc_prepared_xacts
PG_CATALOG	pgxc_thread_wait_status	gs_pgxc_thread_wait_status
PG_CATALOG	pg_comm_delay	gs_comm_delay
PG_CATALOG	pg_comm_recv_stream	gs_comm_recv_stream
PG_CATALOG	pg_comm_send_stream	gs_comm_send_stream
PG_CATALOG	pg_comm_status	gs_comm_status
PG_CATALOG	session_memory	gs_session_memory