Materialized View Memory Space

How to see materialized view occupied memory space?

Asked by: nageshk143 | Member Since Jun-2010 | Asked on: Jun 14th, 2010

View all questions by nageshk143

Return back to Oracle

Answer Question

Showing Answers 1 - 1 of 1 Answers

Answered On : 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

Answer Question

User Panel

Lost Password

Get Activation Code

Interview Coaching

Importance of an MBA for an entrepreneur

Careers and Higher Education Options for BBA Graduates

Have you gone above and beyond your job description?

Describe a time when you had to listen to someone.

What are my options when I do not get a job after graduation?

Has anyone asked you for help? What did you do?

What are the career opportunities available for MCA Graduates?

How do you handle workplace problems?

How do you handle conflict?

How do you handle pressure and stress?

Connect

Question Categories

Oracle DBA FAQ

Interview Question

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Materialized View Memory Space

Give your answer:

Related Answered Questions

Related Open Questions