Go to primary content

Oracle® Argus Insight CMN Profile Global Table Guide Release 8.1 E68410-01 |
| Contents

Previous | Next |

# 3 DATABASE Profile Global Switches

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.

## 3.1 Key 1

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.

## 3.2 Key 2

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.

## 3.3 Key 3

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.

## 3.4 Key 4

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.

## 3.5 Key 5

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.

## 3.6 Key 6

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.

## 3.7 Key 7

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.

## 3.8 Key 8

Section | DATABASE
Key | 8
Company Defined | 0
Name | ETL_TIME
Default Value | 12:00:00 AM
Description | Defines the ETL execution time.

## 3.9 Key 9

Section | DATABASE
Key | 9
Company Defined | 0
Name | ETL_EXECUTE_IMMEDIATE
Default Value | 0
Description | This key is obsolete.

## 3.10 ACCESS

Section | DATABASE
Key | ACCESS
Company Defined | 0
Name | ACCESS
Default Value | COMMON
Description | DO NOT USE. For Oracle internal use only.

## 3.11 APP_OWNER

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.

## 3.12 APP_OWNER_PASSWORD

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.

## 3.13 APP_ROLE

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.

## 3.14 APPLICATION_TYPE

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

## 3.15 COMMIT_AFTER_ROWS

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.

## 3.16 COMMIT_EVERY_TABLE

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.

## 3.17 COMMON_USER

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.

## 3.18 DDL_VER

Section | DATABASE
Key | DDL_VER
Company Defined | 0
Name | DDL_VER
Default Value | 8.1
Description | Specifies the current database version for Argus Insight.

## 3.19 DDL_VER_INITIAL

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.

## 3.20 DEFAULT_SECURITY_ACCESS

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

## 3.21 ETL_COMPUTE_MART_USER_STATISTICS

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.

## 3.22 ETL_COMPUTE_STAGE_USER_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.

## 3.23 ETL_EMAIL_RECEIVER_ADDRESS

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.

## 3.24 ETL_EMAIL_SETUP

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

## 3.25 ETL_STATS_CASCADE_OPTION

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.

## 3.26 ETL_STATS_ESTIMATE_PERCENT

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.

## 3.27 ETL_STATS_METHOD_OPT

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.

## 3.28 ETL_STATS_PARALLEL_DEGREE

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.

## 3.29 ETL_STATUS

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

## 3.30 INCR_ETL_PRE_REQ_STATUS

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.

## 3.31 INCR_ETL_STEP

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.

## 3.32 INCREMENTAL_ETL_STATUS

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

## 3.33 INITIAL_ETL_PRE_REQ_STATUS

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

## 3.34 LAST_ETL_START_DATETIME

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.

## 3.35 LOGIN_OWNER

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.

## 3.36 MART_HIST_OWNER

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.

## 3.37 MART_OWNER

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.

## 3.38 MEMORY_MODEL

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

## 3.39 PRE_REQ_CHECK_FLAG

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.

## 3.40 READ_ONLY_OWNER

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.

## 3.41 READ_ONLY_ROLE

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.

## 3.42 RLS_OWNER

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.

## 3.43 ROLE_NAME

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.

## 3.44 RUN_INCR_ETL_EVERY_TIME

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

## 3.45 SAFETY_DDL_VER

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.

## 3.46 STAGE_OWNER

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.

## 3.47 VERY_FIRST_INITIAL_ETL_COMPLETE

Section | DATABASE
Key | VERY_FIRST_INITIAL_ETL_COMPLETE
Company Defined | 0
Name | VERY FIRST INITIAL ETL COMPLETE
Default Value | 0
Description | Indicates whether the first Initial ETL for Argus Insight has completed. 0 — No 1 — Yes

## 3.48 LOG_REPORT_SQL

Section | DATABASE
Key | LOG_REPORT_SQL
Company Defined | 0
Name | LOG REPORT SQL
Default Value | 0
Description | Identifies if the report SQL is to be logged or not. 0 — No 1 — Yes