| Refreshing Materialized View [message #686659] |
Sun, 13 November 2022 21:21  |
chat2raj.s
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  |
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'; |
|
|
|
] 
Search
Help
Members
Register
Login
Home
