当我右击一个表之后,pl/sql就无响应,新开一个pl/sql在session中查看到有如下语句:
select null from sys.all_mviews
where owner = :object_owner
and mview_name = :object_name
这个是为什么呢。直接查询这个视图也很慢。
select null from sys.all_mviews
where owner = :object_owner
and mview_name = :object_name
这个是为什么呢。直接查询这个视图也很慢。
Name Type Nullable Default Comments
---------------------- ------------- -------- ------- ----------------------------------------------------------------------------
OWNER VARCHAR2(30) Owner of the materialized view
MVIEW_NAME VARCHAR2(30) Name of the materialized view
CONTAINER_NAME VARCHAR2(30) Name of the materialized view container table
QUERY LONG Y The defining query that the materialized view instantiates
......