GOCDB/Regional Module Technical Documentation/Oracle setup

From EGIWiki
< GOCDB‎ | Regional Module Technical Documentation
Revision as of 12:29, 18 December 2012 by Krakow (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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