Home » SQL & PL/SQL » SQL & PL/SQL » Refreshing Materialized View (oracle 10g)
Refreshing Materialized View [message #686659] Sun, 13 November 2022 21:21 Go to next message
Messages: 146
Registered: October 2010
Location: Chennai, India
Senior Member
Dear Sir,
I have created a materialized view with COMPLETE refresh on DEMAND and trying to refresh it and the status is showing as RUNNING without any end or termination to the refreshing. The view on which the MV is created has reference to tables from remote database.

I tried to create a table with the same query and the table got created without any errors which the MV is just in RUNNING status for ever.

How should i debug the issue further.

Thank you
Re: Refreshing Materialized View [message #686662 is a reply to message #686659] Tue, 15 November 2022 01:11 Go to previous message
John Watson
Messages: 8795
Registered: January 2010
Location: Global Village
Senior Member
You could start by seeing if the refresh is actually running or hanging. THis will list all sessions that are hanging, and why:
select username,event,seconds_in_wait from v$session where wait_class <> 'Idle';
Previous Topic: RegEX data parsing
Next Topic: Row into Column and sum two columns
Goto Forum:

Current Time: Mon Feb 06 05:41:14 CST 2023