Difference between revisions of "GOCDB/Regional Module Technical Documentation/Oracle setup"

From EGIWiki
Jump to: navigation, search
Line 1: Line 1:
{{Template:Op menubar}}
{{Template:Op menubar}}
{{Template:Tools menubar}}
{{Template:Tools menubar}}
Back to [[GOCDB/Documentation_Index]] <br/>
Back to [[GOCDB/Documentation_Index]] <br/>

Revision as of 14: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