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

From EGIWiki
Jump to: navigation, search
(Created page with ' Run the following query to list the two GOCDB related jobs (as an oracle system admin user): <pre> SELECT owner, job_name, enabled FROM dba_scheduler_jobs; OWNER …')
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{Template:Op menubar}}
 +
{{Template:GOCDB_menubar}}
 +
{{TOC_right}}
 +
[[Category:GOCDB]]
  
Run the following query to list the two GOCDB related jobs (as an oracle system admin user):
+
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'
 
<pre>
 
<pre>
 
SELECT owner, job_name, enabled FROM dba_scheduler_jobs;
 
SELECT owner, job_name, enabled FROM dba_scheduler_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