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

From EGIWiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{Template:Op menubar}}
 
{{Template:Op menubar}}
{{Template:Tools menubar}}
+
{{Template:GOCDB_menubar}}
Back to [[GOCDB/Documentation_Index]] <br/>
+
{{TOC_right}}
__TOC__
+
[[Category:GOCDB]]
 +
 
 +
You can use any Oracle compliant tool to interact directly with the GOCDB database. We recommend SQLDeveloper or SQL*Plus.
  
 
=== GOCDB Materialized View Jobs ===
 
=== GOCDB Materialized View Jobs ===

Latest revision as of 13:29, 18 December 2012

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