oracle中如何定位你解决问题需要访问地视图

这篇文章主要介绍oracle中如何定位你解决问题需要访问地视图，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！如果你不知道确切要找的目标，可以参考介绍数据字典的文档，或者下面三个视图：DBA_OBJECTSDICTIONARYDICT_COLUMNS如果你知道你大致要查询的方向，比如解决物化视图的问题，可以用一下SQL来进行查询；select object_namefrom dba_objectswhere object_name like ‘%MV%’and owner =’SYS’;OBJECT_NAME——————————————————————————–ALL_BASE_TABLE_MVIEWSALL_MVIEWSALL_MVIEW_AGGREGATESALL_MVIEW_ANALYSISALL_MVIEW_COMMENTSALL_MVIEW_DETAIL_PARTITIONALL_MVIEW_DETAIL_RELATIONSALL_MVIEW_DETAIL_SUBPARTITIONALL_MVIEW_JOINSALL_MVIEW_KEYSALL_MVIEW_LOGS…由于篇幅问题省略部分输出这样可以确保查询方向大致是正确的，但是如果你要看每个视图的详细信息，就要用到DICTIONARY和DICT_COLUMNS这两个视图了；SQL> desc dictionaryName Null? Type—————————————– ——– —————————-TABLE_NAME VARCHAR2(128)COMMENTS VARCHAR2(4000)比如还是要解决物化视图的问题；select table_name,commentsfrom dictionarywhere table_name like ‘%MV%’;TABLE_NAME COMMENTS———————————– —————————————————————————————————-DBA_BASE_TABLE_MVIEWS All materialized views with log(s) in the databaseDBA_HIST_MVPARAMETER Multi-valued Parameter Historical Statistics InformationDBA_MVIEWS All materialized views in the databaseDBA_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to dbaDBA_MVIEW_ANALYSIS Description of the materialized views accessible to dbaDBA_MVIEW_COMMENTS Comments on all materialized views in the databaseDBA_MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the databaseDBA_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables accessible to dbaDBA_MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the databaseDBA_MVIEW_JOINS Description of a join between two columns in the WHERE clause of a materialized view accessible to dbaDBA_MVIEW_KEYS Description of the columns that appear in the GROUP BY list of a materialized view accessible to dbaDBA_MVIEW_LOGS All materialized view logs in the databaseDBA_MVIEW_LOG_FILTER_COLS All filter columns (excluding PK cols) being logged in the materialized view logsDBA_MVIEW_REFRESH_TIMES All fast refreshable materialized views and their last refresh times for each master tableDBA_REGISTERED_MVIEWS Remote materialized views of local tablesDBA_REGISTERED_MVIEW_GROUPS Materialized view repgroup registration informationDBA_TUNE_MVIEW Catalog View to show the result after executing TUNE_MVIEW() APIUSER_BASE_TABLE_MVIEWS All materialized views with log(s) owned by the user in the databaseUSER_MVIEWS All materialized views in the databaseUSER_MVIEW_AGGREGATES Description of the materialized view aggregates created by the userUSER_MVIEW_ANALYSIS Description of the materialized views created by the userUSER_MVIEW_COMMENTS Comments on materialized views owned by the userUSER_MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the databaseUSER_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables of the materialized views created by the userUSER_MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the databaseUSER_MVIEW_JOINS Description of a join between two columns in the WHERE clause of a materialized view created by the userUSER_MVIEW_KEYS Description of the columns that appear in the GROUP BY list of a materialized view created by the userUSER_MVIEW_LOGS All materialized view logs owned by the userUSER_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look atUSER_REGISTERED_MVIEWS Remote materialized views of local tables currently using logs owned by the userUSER_TUNE_MVIEW tune_mview catalog view owned by the userALL_BASE_TABLE_MVIEWS All materialized views with log(s) in the database that the user can seeALL_MVIEWS All materialized views in the databaseALL_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to the userALL_MVIEW_ANALYSIS Description of the materialized views accessible to the userALL_MVIEW_COMMENTS Comments on materialized views accessible to the userALL_MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the databaseALL_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables accessible to the userALL_MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the databaseALL_MVIEW_JOINS Description of a join between two columns in the WHERE clause of a materialized view accessible to the userALL_MVIEW_KEYS Description of the columns that appear in the GROUP BYlist of a materialized view accessible to the userALL_MVIEW_LOGS All materialized view logs in the database that the user can seeALL_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look atALL_REGISTERED_MVIEWS Remote materialized views of local tables that the user can seeGV$MVREFRESH Synonym for GV_$MVREFRESHV$MVREFRESH Synonym for V_$MVREFRESH46 rows selected.如果这还不能获得足够的相关列名信息，可以查询DICT_COLUMNS视图，还可以使用如下SQL来进行查询；select column_name,commentsfrom dict_columnswhere table_name = ‘DBA_MVIEWS’;COLUMN_NAME COMMENTS—————————————- —————————————————————————————————-UNKNOWN_PLSQL_FUNC Indicates if the materialized view contains PL/SQL functionUNKNOWN_EXTERNAL_TABLE Indicates if the materialized view contains external tablesUNKNOWN_CONSIDER_FRESH Indicates if the materialized view is considered freshUNKNOWN_IMPORT Indicates if the materialized view is importedUNKNOWN_TRUSTED_FD Indicates if the materialized view used trusted constraints for refreshCOMPILE_STATE Indicates the validity of the MV meta-dataUSE_NO_INDEX Indicates whether the MV uses no indexSTALE_SINCE Time from when the materialized view became staleNUM_PCT_TABLES Number of PCT detail tablesNUM_FRESH_PCT_REGIONS Number of fresh PCT partition regionsNUM_STALE_PCT_REGIONS Number of stale PCT partition regionsSEGMENT_CREATED Whether the materialized view segment is created or notEVALUATION_EDITION Name of the evaluation edition assigned to the materialized view subqueryUNUSABLE_BEFORE Name of免费云主机域名 the oldest edition eligible for query rewriteUNUSABLE_BEGINNING Name of the oldest edition in which query rewrite becomes perpetually disabledOWNER Owner of the materialized viewMVIEW_NAME Name of the materialized viewCONTAINER_NAME Name of the materialized view container tableQUERY The defining query that the materialized view instantiatesQUERY_LEN The number of bytes in the defining query (based on the server character setUPDATABLE Indicates whether the materialized view can be updatedUPDATE_LOG Name of the table that logs changes to an updatable materialized viewMASTER_ROLLBACK_SEG Name of the rollback segment to use at the master siteMASTER_LINK Name of the database link to the master siteREWRITE_ENABLED Indicates whether rewrite is enabled for the materialized viewREWRITE_CAPABILITY Indicates the kind of rewrite that is enabledREFRESH_MODE Indicates how and when the materialized view will be refreshedREFRESH_METHOD The default refresh method for the materialized view (complete, fast, …)BUILD_MODE How and when to initially build (load) the materialized view containerFAST_REFRESHABLE Indicates the kinds of operations that can be fast refreshed for the MVLAST_REFRESH_TYPE Indicates the kind of refresh that was last performed on the MVLAST_REFRESH_DATE The date that the materialized view was last refreshedLAST_REFRESH_END_TIME The time that the last materialized view refresh endedSTALENESS Indicates the staleness state of the materialized view (fresh, stale, …)AFTER_FAST_REFRESH Indicates the staleness state the MV will have after a fast refresh is doneUNKNOWN_PREBUILT Indicates if the materialized view is prebuilt36 rows selected.以上是“oracle中如何定位你解决问题需要访问地视图”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注百云行业资讯频道！

相关推荐: oracle事务知识点整理

这篇文章主要介绍“oracle事务知识点整理”，在日常操作中，相信很多人在oracle事务知识点整理问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”oracle事务知识点整理”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！DML…