1 Reply Latest reply: Nov 9, 2012 7:14 AM by spajdy RSS

    Materialized view refresh group - how do I see how long the refresh took?

    77774
      [reposted from XE forum]
      I'm doing some testing with Oracle XE 11.2 (on Ubuntu 12.04) replicating tables from a remote db into materialized views. I've successfully replicated some tables, and created a refresh group for the tables. There are a number of frustrations:
      1. how long is the refresh taking? I can look in dba_jobs/all_jobs to see when it last ran, and when it is due to next run, but I haven't found where the job/refresh duration is.
      2. the only logs seem to be .trc files in $ORACLE_HOME/diag/rdbms/xe/XE/trace; there's no equivalent of dba_scheduler_job_log for refresh group jobs. Or is there?
      3. how are these jobs run? I see entries in dba_jobs, but nothing matching in dba_scheduler_jobs. So it uses the old-school dbms_job mechanism?

      The general lack of visibility into the refresh mechanism is a bit concerning.

      Thanks,
      Alistair