Difference between revisions of "GOCDB/Regional Module Technical Documentation/Oracle setup"
Jump to navigation
Jump to search
(Created page with ' Run the following query to list the two GOCDB related jobs (as an oracle system admin user): <pre> SELECT owner, job_name, enabled FROM dba_scheduler_jobs; OWNER …') |
|||
Line 1: | Line 1: | ||
Run the following query to list the two GOCDB related jobs (as an oracle system admin user) | === GOCDB Materialized View Jobs === | ||
Run the following query to list the two GOCDB related jobs (as an oracle system admin user). You should see the two GOCDB jobs listed 'MV_SE_PK_REFRESH' and 'MV_SITES_PK_REFRESH' | |||
<pre> | <pre> | ||
SELECT owner, job_name, enabled FROM dba_scheduler_jobs; | SELECT owner, job_name, enabled FROM dba_scheduler_jobs; |
Revision as of 12:32, 24 May 2011
GOCDB Materialized View Jobs
Run the following query to list the two GOCDB related jobs (as an oracle system admin user). You should see the two GOCDB jobs listed 'MV_SE_PK_REFRESH' and 'MV_SITES_PK_REFRESH'
SELECT owner, job_name, enabled FROM dba_scheduler_jobs; OWNER JOB_NAME ENABLED ------------------------------ ------------------------------ ------- SYS PURGE_LOG TRUE SYS FGR$AUTOPURGE_JOB FALSE SYS GATHER_STATS_JOB TRUE SYS AUTO_SPACE_ADVISOR_JOB FALSE GOCDB MV_SE_PK_REFRESH TRUE GOCDB MV_SITES_PK_REFRESH TRUE