Materialized views
Hi
The Materialized refresh job defined in dba_job is not executing since a week.
I have checked with the basic troubleshooting :
1) Job_que_processes
2) Checked with Mview master object(source table) whether the source table is modified recently which may have invalidated mview in getting refreshed
3) Checked with db_link , which is used for refresh , and it is working fine ( as other materialized views get refresh thru same db_link)
4)network is good
5) Materialized view logs ----i need some help on this ...can this be a reason that mview logs are growing larger ?
The table consists of only 24101 rows. Kindly suggest how should i troubleshoot further ....
The Materialized refresh job defined in dba_job is not executing since a week.
I have checked with the basic troubleshooting :
1) Job_que_processes
2) Checked with Mview master object(source table) whether the source table is modified recently which may have invalidated mview in getting refreshed
3) Checked with db_link , which is used for refresh , and it is working fine ( as other materialized views get refresh thru same db_link)
4)network is good
5) Materialized view logs ----i need some help on this ...can this be a reason that mview logs are growing larger ?
The table consists of only 24101 rows. Kindly suggest how should i troubleshoot further ....
0