Application Considerations
Review the following:
Parent topic: Configuration Guide for Non-Exadata
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
).
Parent topic: Application Considerations
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.
Parent topic: Application Considerations
Cohort Data Model
See Oracle Healthcare Translational Research Installation Guide for Non-Exadata specific configurable partitioning and parallel options.
Parent topic: Application Considerations
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.
Parent topic: Application Considerations