Always Use DBMS_RANDOM in Oracle Data Sources

Administrators use this system setting to specify whether Contextual Insight algorithms use the DBMS_RANDOM package in Oracle data sources to generate random numbers.

Valid Values

  • On — Contextual Insights always use the DBMS_RANDOM package in Oracle data sources for random number generation. Default
  • Off — Contextual Insights uses the value of the RAND_SUPPORTED property to determine whether or not to use the DBMS_RANDOM database feature. Semantic modelers can set the RAND_SUPPORTED property to ON or OFF in the query features selection pane for their Oracle data source. See Modify a Database's Data Source Properties and Supported Query Features. If RAND_SUPPORTED is OFF, the ORA_HASH function is used.

Apply Required

Yes.

Change Effective

After a few minutes.

Edition

Enterprise only.

API Key and Values

API Key — AlwaysUseDBMSRANDOMOracleDataSources

API Values —
  • true
  • false

Documentation Links