Alert.png The wiki is deprecated and due to be decommissioned by the end of September 2022.
The content is being migrated to other supports, new updates will be ignored and lost.
If needed you can get in touch with EGI SDIS team using operations @ egi.eu.

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 Jump to 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