Difference between revisions of "GOCDB/Regional Module Technical Documentation/Oracle setup"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
{{Template:Op menubar}} | |||
{{Template:Tools menubar}} | |||
Back to [[GOCDB/Documentation_Index]] <br/> | |||
__TOC__ | |||
=== GOCDB Materialized View Jobs === | === GOCDB Materialized View Jobs === |
Revision as of 12:34, 24 May 2011
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