OraFAQ Forum: Server Administration » list materialized views that are rebuilding at this moment

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

list materialized views that are rebuilding at this moment [message #627840]

Mon, 17 November 2014 07:44

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

Report message to a moderator

Re: list materialized views that are rebuilding at this moment [message #627845 is a reply to message #627840]

Mon, 17 November 2014 07:57

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try to query DBA_REFRESH join with DBA_JOBS_RUNNING

Report message to a moderator

Re: list materialized views that are rebuilding at this moment [message #627846 is a reply to message #627845]

Mon, 17 November 2014 08:09

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Or better: V$MVREFRESH

Report message to a moderator

Re: list materialized views that are rebuilding at this moment [message #627851 is a reply to message #627846]

Mon, 17 November 2014 08:38

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.

Report message to a moderator

Previous Topic:	NLS_Character set
Next Topic:	Oracle Licensing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:21:44 CST 2025