Downs DB Developer Candidate Exercises v1.3 1. Materialized Views After reading the hypothetical situation described below, explain 1. What most likely happened? 2. How you would go about figuring out why it happened? You have a materialized view SOMESCHEMA.SOMETABLE in an Oracle database that replicates rows from another Oracle database. It is refreshed every night. While the materialized view has tens of millions of rows in it, it typically does an incremental refresh and the refresh completes in less than a minute. One morning sessions performing writes on your database are failing with many "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS" When you run the following query: SELECT owner, mview name master link, refresh method, fast refreshable, last refresh type FROM dba mviews WHERE owner'SOMESCHEMA' AND mview name'SOMETABLE You get the following output REFRESH METHO FAST REFRESHAB NER MVIEW NAME MASTER LINK LAST REFRESH SOME REMOTE DB.EXAMPLE.CO SOMESCHEMA SOMETABLE DIRLOAD DML OMPLETE