GOCDB/Regional Module Technical Documentation/Oracle setup
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Main | EGI.eu operations services | Support | Documentation | Tools | Activities | Performance | Technology | Catch-all Services | Resource Allocation | Security |
GOC DB menu: | Home • | 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