[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.
It is using old-school job mechanism (dba_jobs,dbms-job).
There is nto any view like dba_scheduler_job_log. But in dba_jobs view there is columnt total_time. After aech job run is it increased. So if you remember value when job start you can count how log was job running.