Submitted Questions
Materialized view memory space
Asked By: nageshk143
| Asked On: Jun 14th, 2010
How to see materialized view occupied memory space?
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
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