Home » RDBMS Server » Server Administration » list materialized views that are rebuilding at this moment (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0)
list materialized views that are rebuilding at this moment [message #627840] Mon, 17 November 2014 07:44 Go to next message
ecivgamer
Messages: 147
Registered: May 2011
Location: Ukraine
Senior Member
Hi all,

how do I list materialized views that are rebuilding at this moment?


select * from v$version
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
Re: list materialized views that are rebuilding at this moment [message #627845 is a reply to message #627840] Mon, 17 November 2014 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Try to query DBA_REFRESH join with DBA_JOBS_RUNNING

Re: list materialized views that are rebuilding at this moment [message #627846 is a reply to message #627845] Mon, 17 November 2014 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Or better: V$MVREFRESH

Re: list materialized views that are rebuilding at this moment [message #627851 is a reply to message #627846] Mon, 17 November 2014 08:38 Go to previous message
ecivgamer
Messages: 147
Registered: May 2011
Location: Ukraine
Senior Member
Michel Cadot wrote on Mon, 17 November 2014 16:09

Or better: V$MVREFRESH



Thanks, Michel Cadot.
Previous Topic: NLS_Character set
Next Topic: Oracle Licensing
Goto Forum:
  


Current Time: Mon Oct 22 11:21:12 CDT 2018