GOCDB/Regional Module Technical Documentation/Oracle setup

From EGIWiki
< GOCDB‎ | Regional Module Technical Documentation
Revision as of 11:25, 24 May 2011 by Davidm (talk | contribs) (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 …')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Run the following query to list the two GOCDB related jobs (as an oracle system admin user):

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