When a new feature of Oracel comes out, we may not know all the data dictionary names associated with this feature,
So how do you get meta data for these meta data?
Can be viewed through Dicitonary:
For example, find a list of data dictionary names with memory in all the names:
Sql> Col table_name for A30
Sql> Col comments for A80
Sql>select table_name,comments from dictionary where table_name like '%memory% ';
TABLE_NAME COMMENTS
------------------------------ --------------------------------------------------------------------------------
Dba_hist_memory_resize_ops MEMORY RESIZE Operations History
Dba_hist_memory_target_advice MEMORY TARGET ADVICE History
V$inmemory_area synonym for V_$inmemory_area
V$java_library_cache_memory synonym for V_$java_library_cache_memory
V$library_cache_memory synonym for V_$library_cache_memory
V$sga_dynamic_free_memory synonym for V_$sga_dynamic_free_memory
Gv$memory_current_resize_ops synonym for Gv_$memory_current_resize_ops
gv$memory_dynamic_components synonym for Gv_$memory_dynamic_components
Gv$memory_resize_ops synonym for Gv_$memory_resize_ops
Gv$memory_target_advice synonym for Gv_$memory_target_advice
Gv$process_memory synonym for Gv_$process_memory
TABLE_NAME COMMENTS
------------------------------ --------------------------------------------------------------------------------
Gv$process_memory_detail synonym for Gv_$process_memory_detail
Gv$process_memory_detail_prog synonym for Gv_$process_memory_detail_prog
Gv$result_cache_memory synonym for Gv_$result_cache_memory
Gv$inmemory_area synonym for Gv_$inmemory_area
Gv$java_library_cache_memory synonym for Gv_$java_library_cache_memory
Gv$library_cache_memory synonym for Gv_$library_cache_memory
Gv$sga_dynamic_free_memory synonym for Gv_$sga_dynamic_free_memory
Gv$sql_shared_memory synonym for Gv_$sql_shared_memory
V$memory_current_resize_ops synonym for V_$memory_current_resize_ops
v$memory_dynamic_components synonym for V_$memory_dynamic_components
V$memory_resize_ops synonym for V_$memory_resize_ops
TABLE_NAME COMMENTS
------------------------------ --------------------------------------------------------------------------------
V$memory_target_advice synonym for V_$memory_target_advice
V$process_memory synonym for V_$process_memory
V$process_memory_detail synonym for V_$process_memory_detail
V$process_memory_detail_prog synonym for V_$process_memory_detail_prog
V$result_cache_memory synonym for V_$result_cache_memory
V$sql_shared_memory synonym for V_$sql_shared_memory
Sql>
[Oracle] [Metadata] How to find the name of a data dictionary associated with a feature