This chapter lists the DATABASE profile global switches for Argus Insight.
For information about the profile global switches you can use to change settings for your system or for your related application (Argus Safety), see Chapter 2, "SYSTEM Profile Global Switches" and Chapter 4, "Profile Global Switches for Related Applications," respectively.
Section | DATABASE |
Key | 1 |
Company Defined | 0 |
Name | ETL_SUNDAY |
Default Value | 0 |
Description | Argus Insight uses this record to determine whether Extract Transform and Load (ETL) will execute on Sunday. |
Section | DATABASE |
Key | 2 |
Company Defined | 0 |
Name | ETL_MONDAY |
Default Value | 0 |
Description | Argus Insight uses this record to determine whether ETL will execute on Monday. |
Section | DATABASE |
Key | 3 |
Company Defined | 0 |
Name | ETL_TUESDAY |
Default Value | 0 |
Description | Argus Insight uses this record to determine whether ETL will execute on Tuesday. |
Section | DATABASE |
Key | 4 |
Company Defined | 0 |
Name | ETL_WEDNESDAY |
Default Value | 0 |
Description | Argus Insight uses this record to determine whether ETL will execute on Wednesday. |
Section | DATABASE |
Key | 5 |
Company Defined | 0 |
Name | ETL_THURSDAY |
Default Value | 0 |
Description | Argus Insight uses this record to determine whether ETL will execute on Thursday. |
Section | DATABASE |
Key | 6 |
Company Defined | 0 |
Name | ETL_FRIDAY |
Default Value | 0 |
Description | Argus Insight uses this record to determine whether ETL will execute on Friday. |
Section | DATABASE |
Key | 7 |
Company Defined | 0 |
Name | ETL_SATURDAY |
Default Value | 0 |
Description | Argus Insight uses this record to determine whether ETL will execute on Saturday. |
Section | DATABASE |
Key | 8 |
Company Defined | 0 |
Name | ETL_TIME |
Default Value | 12:00:00 AM |
Description | Defines the ETL execution time. |
Section | DATABASE |
Key | 9 |
Company Defined | 0 |
Name | ETL_EXECUTE_IMMEDIATE |
Default Value | 0 |
Description | This key is obsolete. |
Section | DATABASE |
Key | ACCESS |
Company Defined | 0 |
Name | ACCESS |
Default Value | COMMON |
Description | DO NOT USE. For Oracle internal use only. |
Section | DATABASE |
Key | APP_OWNER |
Company Defined | 0 |
Name | APP OWNER |
Default Value | APR_APP |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle application schema name for Argus Insight. |
Section | DATABASE |
Key | APP_OWNER_PASSWORD |
Company Defined | 0 |
Name | APP OWNER PASSWORD |
Default Value | — |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle application schema password for Argus Insight. |
Section | DATABASE |
Key | APP_ROLE |
Company Defined | 0 |
Name | APP ROLE |
Default Value | APR_APP_ROLE |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle application role name for Argus Insight. |
Section | DATABASE |
Key | APPLICATION_TYPE |
Company Defined | 0 |
Name | APPLICATION TYPE |
Default Value | 1 |
Description | DO NOT USE. For Oracle internal use only.
Defines the type of installation for Argus Insight. 0 — Single tenant installation 1 — Multi-tenant installation |
Section | DATABASE |
Key | COMMIT_AFTER_ROWS |
Company Defined | 0 |
Name | ETL - COMMIT_AFTER_ROWS |
Default Value | 10000 |
Description | Sets the number of cases that the Incremental ETL processes before committing the data to the database. |
Section | DATABASE |
Key | COMMIT_EVERY_TABLE |
Company Defined | 0 |
Name | ETL - COMMIT_EVERY_TABLE |
Default Value | FALSE |
Description | Sets the configuration flag for Incremental ETL execution to perform an Oracle commit after processing one table.
TRUE — Incremental ETL commits data after every table. FALSE — Incremental ETL does not commit data after every table. Instead, Incremental ETL commits the data only after the end of the mart processing. |
Section | DATABASE |
Key | COMMON_USER |
Company Defined | 0 |
Name | COMMON USER |
Default Value | APR_LOGIN |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle login schema name for Argus Insight. |
Section | DATABASE |
Key | DDL_VER |
Company Defined | 0 |
Name | DDL_VER |
Default Value | 8.0 |
Description | Specifies the current database version for Argus Insight. |
Section | DATABASE |
Key | DDL_VER_INITIAL |
Company Defined | 0 |
Name | DDL_VER_INITIAL |
Description | Specifies the initial version of the schema creation for Argus Insight. |
Section | DATABASE |
Key | DEFAULT_SECURITY_ACCESS |
Company Defined | 0 |
Name | DEFAULT_SECURITY_ACCESS |
Default Value | 0 |
Description | DO NOT USE. For Oracle internal use only.
Defines the default security access to Argus data (site, study, and product) for all Argus Insight users. 0 — Full access 8 — No access |
Section | DATABASE |
Key | ETL_COMPUTE_MART_USER_STATISTICS |
Company Defined | 0 |
Name | ETL_MART_USER_STATISTICS |
Default Value | 1 |
Description | Defines how ETL should compute statistics for the mart user.
0 — Disabled (no statistics computed) 1 — Use the Oracle DBMS_STATS method to compute the statistics. DBMS_STATS is the preferred method for computing statistics. 2 — Use the Oracle ANALYZE method to compute the statistics. |
Section | DATABASE |
Key | ETL_COMPUTE_STAGE_USER_STATISTICS |
Company Defined | 0 |
Name | ETL_STAGE_USER_STATISTICS |
Default Value | 1 |
Description | Defines how ETL should compute statistics for the stage user.
0 — Disabled (no statistics computed) 1 — Use the Oracle DBMS_STATS method to compute the statistics. DBMS_STATS is the preferred method for computing statistics. 2 — Use the Oracle ANALYZE method to compute the statistics. |
Section | DATABASE |
Key | ETL_EMAIL_RECEIVER_ADDRESS |
Company Defined | 1 |
Name | ETL EMAIL RECEIVER ADDRESS |
Default Value | — |
Description | Defines the email address of each administrator who will receive email status messages of the ETL process. Use a semi-colon to separate each entry. If you leave the value blank, then Argus Insight sends no email messages. |
Section | DATABASE |
Key | ETL_EMAIL_SETUP |
Company Defined | 1 |
Name | ETL EMAIL SETUP |
Default Value | 0 |
Description | Defines whether to send an email after ETL is run and under what circumstances to send the email.
0 — Do not send an email after any ETL process 1 — Send an email only when an Initial ETL or an Incremental ETL fails 2 — Send an email only when an Initial ETL or an Incremental ETL succeeds 3 — Send an email after every Initial ETL or Incremental ETL regardless of whether the process succeeds or fails |
Section | DATABASE |
Key | ETL_STATS_CASCADE_OPTION |
Company Defined | 0 |
Name | ETL STATS CASCADE OPTION |
Default Value | TRUE |
Description | Specifies (TRUE or FALSE) whether to use the Oracle Cascade option for computing statistics for the mart user. |
Section | DATABASE |
Key | ETL_STATS_ESTIMATE_PERCENT |
Company Defined | 0 |
Name | ETL STATS ESTIMATE PERCENT |
Default Value | 1 |
Description | Sets the estimate percentage for computing statistics for the mart user. |
Section | DATABASE |
Key | ETL_STATS_METHOD_OPT |
Company Defined | 0 |
Name | ETL STATS METHOD OPT |
Default Value | FOR ALL COLUMNS SIZE AUTO |
Description | Defines the METHOD_OPT parameter for the Oracle DBMS_STATS method used when computing ETL schema statistics. |
Section | DATABASE |
Key | ETL_STATS_PARALLEL_DEGREE |
Company Defined | 0 |
Name | PARALLEL DEGREE IN DBMS_STATS |
Default Value | — |
Description | Defines the DEGREE parameter for the Oracle DBMS_STATS method used when computing ETL schema statistics. |
Section | DATABASE |
Key | ETL_STATUS |
Company Defined | 0 |
Name | ETL_STATUS |
Default Value | 0 |
Description | Provides the status of the current ETL.
-1 — Initial ETL started 1 — Initial ETL completed -2 — Incremental ETL started 2 — Incremental ETL completed |
Section | DATABASE |
Key | INCR_ETL_PRE_REQ_STATUS |
Company Defined | 0 |
Name | INCR_ETL_PRE_REQ_STATUS |
Default Value | — |
Description | DO NOT USE. For Oracle internal use only. |
Section | DATABASE |
Key | INCR_ETL_STEP |
Company Defined | 0 |
Name | INCR_ETL_STEP |
Default Value | 0 |
Description | DO NOT USE. For Oracle internal use only. |
Section | DATABASE |
Key | INCREMENTAL_ETL_STATUS |
Company Defined | 0 |
Name | INCREMENTAL_ETL_STATUS |
Default Value | 0 |
Description | Provides status information about the Incremental ETL.
0 — Indicates either the Incremental ETL has not started or the pre-incremental tasks are in process 1 — Indicates the pre-incremental tasks have completed |
Section | DATABASE |
Key | INITIAL_ETL_PRE_REQ_STATUS |
Company Defined | 0 |
Name | INITIAL ETL PRE REQ STATUS |
Default Value | — |
Description | DO NOT USE. For Oracle internal use only.
Provides information about the Initial ETL process. 1 — No errors 2 — Ignore errors and proceed 3 — Abort ETL |
Section | DATABASE |
Key | LAST_ETL_START_DATETIME |
Company Defined | 0 |
Name | LAST ETL START TIME |
Default Value | — |
Description | Contains the date and time that the last ETL started. |
Section | DATABASE |
Key | LOGIN_OWNER |
Company Defined | 0 |
Name | LOGIN OWNER |
Default Value | APP_USER |
Description | DO NOT USE. For Oracle internal use only.
Specifies the Oracle APR APP schema name for Argus Insight. |
Section | DATABASE |
Key | MART_HIST_OWNER |
Company Defined | 0 |
Name | MART HISTORY OWNER |
Default Value | APR_HIST |
Description | DO NOT USE. For Oracle internal use only.
Specifies the Oracle history schema name for Argus Insight. |
Section | DATABASE |
Key | MART_OWNER |
Company Defined | 0 |
Name | MART OWNER |
Default Value | APR_MART |
Description | DO NOT USE. For Oracle internal use only.
Oracle MART schema name for Argus Insight. |
Section | DATABASE |
Key | MEMORY_MODEL |
Company Defined | 0 |
Name | MEMORY MODEL |
Default Value | 0 |
Description | DO NOT USE. For Oracle internal use only.
Stores the memory model used to create schema. The Schema Creation Tool sets this value based on user selection. 0 — Default (Oracle internal use only.) 1 — Small 2 — Medium 3 — Large |
Section | DATABASE |
Key | PRE_REQ_CHECK_FLAG |
Company Defined | 1 |
Name | ETL DATA EXCLUSION |
Default Value | IGNORE |
Description | Specifies whether to continue or cancel the ETL process if cases with erroneous data are found.
IGNORE — Continue the ETL but skip cases with erroneous data. ABORT — Cancel the ETL if any cases with erroneous data are found. |
Section | DATABASE |
Key | READ_ONLY_OWNER |
Company Defined | 0 |
Name | READ ONLY OWNER |
Default Value | APR_LINK_USER |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle read-only schema name for Argus Insight. |
Section | DATABASE |
Key | READ_ONLY_ROLE |
Company Defined | 0 |
Name | READ ONLY ROLE |
Default Value | APR_LINK_ROLE |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle read-only role name for Argus Insight. |
Section | DATABASE |
Key | RLS_OWNER |
Company Defined | 0 |
Name | RLS OWNER |
Default Value | APR_RLS |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle Virtual Private Database (VPD) schema name for Argus Insight. |
Section | DATABASE |
Key | ROLE_NAME |
Company Defined | 0 |
Name | ROLE NAME |
Default Value | APR_ROLE |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle role name for Argus Insight. |
Section | DATABASE |
Key | RUN_INCR_ETL_EVERY_TIME |
Company Defined | 0 |
Name | RUN INCR ETL EVERY TIME |
Default Value | 1 |
Description | Defines whether to run Incremental ETL only if data has changed.
0 — Only run Incremental ETL if the case data, report data, or LAM data has changed 1 — Always run Incremental ETL regardless of whether there are any changes to the case data, report data, or LAM data |
Section | DATABASE |
Key | SAFETY_DDL_VER |
Company Defined | 0 |
Name | ARGUS SAFETY VERSION |
Default Value | SELECT VALUE FROM cmn_profile@db_link_argus
WHERE KEY = 'DDL_VER' AND section = 'DATABASE' |
Description | Specifies the current version of Argus Safety. |
Section | DATABASE |
Key | STAGE_OWNER |
Company Defined | 0 |
Name | STAGE OWNER |
Default Value | APR_STAGE |
Description | DO NOT USE. For Oracle internal use only.
Defines the Oracle STAGE schema name for Argus Insight. |