GOCDB/Regional Module Technical Documentation/Oracle setup

From EGIWiki
Jump to: navigation, search
Main EGI.eu operations services Support Documentation Tools Activities Performance Technology Catch-all Services Resource Allocation Security


Tools menu: Main page Instructions for developers AAI Proxy Accounting Portal Accounting Repository AppDB ARGO GGUS GOCDB
Message brokers Licenses OTAGs Operations Portal Perun EGI Collaboration tools LToS EGI Workload Manager


Back to GOCDB/Documentation_Index

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