[Oracle] [Metadata] How to find the name of a data dictionary associated with a feature

Source: Internet
Author: User


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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.