Application Considerations

Review the following:

• General Recommendations
  
• Oracle Healthcare Foundation
  
• Cohort Data Model
  
• Omics Loaders
  

General Recommendations

• Oracle Table or Schema Statistics:

  Configure the scheduled jobs to collect the Oracle statistics using the following method. This should be configured after the initial load is complete.

  BEGINDBMS_SCHEDULER.create_job ( job_name => 'OWNER_STATS', job_type => 'PLSQL_BLOCK', job_action => q'[BEGIN dbms_stats.gather_schema_stats (ownname=> 'OWNER', method_opt=> 'for all columns size auto', estimate_percent=> dbms_ stats.auto_sample_ size, cascade=>true, block_sample => true, options => 'GATHER STALE'); END;]', start_date => sysdate, repeat_interval => 'FREQ=DAILY;BYHOUR=0', end_date => NULL, enabled => TRUE, comments => 'Table stats gathering job for OWNER.');END;/

• Data files or flat files (for example, ODB result and reference data files) should be staged on Database File System (DBFS) as the Oracle Database provides much better security, availability, robustness, transactions, and scalability than the traditional file systems. For setting up DBFS, see article ID 1054431.1 on My Oracle Support (https://support.oracle.com).

Oracle Healthcare Foundation

Oracle Table or Schema Statistics:

HDI source tables should have proper table statistics before the initial load. See Oracle Healthcare Foundation Administrator's Guide for ETL-specific recommendations regarding parallel options.

Cohort Data Model

See Oracle Healthcare Translational Research Installation Guide for Non-Exadata specific configurable partitioning and parallel options.

Omics Loaders

• Run the result files in parallel to achieve maximum performance.
• See Data Model Installation for Non-Exadata specific configurable partitioning and parallel options.