Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1741
  • Last Modified:

Oracle Materialized View - How to find last Refresh Stats on View

Is there a sys view I can query to find out the last run date stats on a particular materialized view?

thanks
0
iBinc
Asked:
iBinc
  • 4
  • 3
1 Solution
 
mrjoltcolaCommented:
DBA_MVIEWS.LAST_REFRESH_DATE
0
 
mrjoltcolaCommented:
select last_refresh_type, last_refresh_date, staleness from dba_mviews where mview_name = 'MYVIEW';

You may also use USER_MVIEWS if not a DBA

0
 
iBincAuthor Commented:
Tried using the user_mviews but the table is empty. I think this user is read only to the source. Any way around that?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
iBincAuthor Commented:
user_mviews doesn't return anything even where I have dba access. ??
0
 
mrjoltcolaCommented:
Try ALL_MVIEWS

If you don't it there, you really should check DBA_MVIEWS to be sure it even exists.

DBA_MVIEWS will show all in the system
USER_MVIEWS only shows what you have privileges for.

Who owns the mview?
0
 
iBincAuthor Commented:
all_mviews works for me!

Thanks for all your contributions!
0
 
mrjoltcolaCommented:
You are very welcome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now