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:Op menubar}} | ||
{{Template:Tools menubar}} | {{Template:Tools menubar}} | ||
[[Category:GOCDB]] | |||
Back to [[GOCDB/Documentation_Index]] <br/> | Back to [[GOCDB/Documentation_Index]] <br/> | ||
__TOC__ | __TOC__ |
Revision as of 15:10, 15 October 2012
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
You can use any Oracle compliant tool to interact directly with the GOCDB database. We recommend SQLDeveloper or SQL*Plus.
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