Materialized View Memory Space

How to see materialized view occupied memory space?

Questions by nageshk143

Showing Answers 1 - 2 of 2 Answers

PK

  • Feb 29th, 2012
 

There is a data dictionary called as ALL_MVIEWS.
You can check the query and the length of the query in this data dictionary as

Select * from ALL_MVIEWS where MVIEW_NAME = MVIEWNAME

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions