GOCDB/Regional Module Technical Documentation/Oracle setup
Jump to navigation
Jump to 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