Oracle Discoverer 4i Configuration Guide for Oracle9i Application Server Release 4.1 for Windows NT A87430-01 |
Library | Service | Contents | Index

# C
Discoverer 4i Registry Settings

## C.1 Registry settings in pref.txt

For more information about changing Registry settings in the pref.txt file, refer to Section 2.4, "Editing the End User Preferences".

#####

Affected Feature | Preference Item Key Name | Description | Default/Values
--- | --- | --- | ---
Locator | MachineIPs | IP addresses or machine names of all Discoverer Server Application server. This is the only required item in the pref.txt file. |
| DCW4_LOCATOR_JVM | Optional key. If present in the Registry under HKEY_LOCAL_ MACHINE | SOFTWARE | ORACLE, it should point to the path of a JVM used by the Locator. Setting this key allows the Discoverer administrator to log off the machine where the Locator is installed without also stopping the Locator. |
Administrator | ShowUserTypeChoice | Activates an end-user checkbox that allows users to specify whether they want to run Discoverer Plus against an Oracle Application. Not used by Discoverer Viewer (specified in viewer_config.xml instead). | 0 ( 0=hide checkbox, 1=show checkbox)
| DefaultUserTypeIsApps | Specifies that users run Discoverer Plus by default against an Oracle Application. Not used by Discoverer Viewer (specified in disco4iv.xml instead). | 0 (0=No, 1=Yes)
Session Manager | Timeout | Amount of time after which Discoverer 4i disconnects an idle session from the database. Minimum time is 180 seconds. | 1800 (seconds)
| RowsPerHTML | Number of rows to display per HTML page. | 25 (any whole number)
Application | CacheFlushPercentage | Percentage of cache flushed if the cache is full. | 25
| MaxVirtualDiskMem | Maximum amount of disk memory allowed for the data cache. | 1024000000
| MaxVirtualHeapMem | Maximum amount of heap memory allowed for the data cache. | 1024000000
| QueryBehavior | Action to take after opening a workbook. | 0 (0 = Run Query Automatically, 1 = Don't Run Query, 2 = Ask for Confirmation)
| ShowDialogBitmaps | End users see the bitmap graphics on Discoverer Plus dialogs. | 1 (0 = off, 1 = on)
| DataFormat | Applies HTML formatting to data cells in worksheets. | "<fontFormat fontName="Dialog" pitch="10" bold="false" italic="false" underline="false" strikethrough="false" foreground="0,0,0" background="255, 255, 255" halign="right" valign="top"></fontFormat>"
| HeadingFormat | Applies HTML formatting to heading cells in worksheets. | "<fontFormat fontName="Dialog" pitch="10" bold="false" italic="false" underline="false" strikethrough="false" foreground="0,0,0" background="204, 204, 204" halign="left" valign="top"></fontFormat>"
| TotalsFormat | Applies HTML formatting to cells that contain totals in worksheets. | "<fontFormat fontName="Dialog" pitch="10" bold="false" italic="false" underline="false" strikethrough="false" foreground="0,0,0" background="255, 255, 255" halign="left" valign="top"></fontFormat>"
| NullValue | Specifies how null values are displayed in worksheets, for example, "NULL", "N/A", "0". | "NULL"
Database | DisableFanTrapDetection | Disables detection for fan trap in user queries. | 0 (0 = on, 1 = off)
| DisableMultiJoinDetection | Disables multiple join detection. | 1 (0 = on, 1 = off)
| DisableAutoQuery | If set to 0, queries do not automatically run when a worksheet opens. | 0 (0 = on, 1 = off)
| DisableAutoOuterJoinsOn Filters | Turn off Automatic Outer Joins on filters. | 0 (0 = on, 1 = off)
| ItemClassDelay | Fetch list of values for this amount of time before timing out. | 15 (seconds)
| PredictionThresholdSeconds | Warn user if the predicted query time will exceed the number of seconds. | 60 (seconds)
| PredictionThresholdSeconds Enabled | Query prediction threshold disabled (0) or enabled (1). | 1
| QueryTimeLimit | Limit on query time in seconds. | 1800 (seconds)
| QueryTimeLimitEnabled | Query time limit disabled (0) or enabled (1). | 1
| RowFetchLimit | The maximum number of rows fetched. | 10000 (rows)
| RowFetchLimitEnabled | RowFetchLimit parameter is disabled (0) or enabled (1). | 1
| RowsPerFetch | The number of rows to fetch at once. | 100 (rows)
| SummaryThreshold | Use summary table only if it is no older than this number of days. | 30 (days) 0 do not use summary at all
| SummaryThresholdEnabled | If enabled (1), will use the value specified by SummaryThreshold. Otherwise, Discoverer will always use summary tables if they are available. | 1
| MaterializedViewRedirectionBehavior | 8.1.6 Materialized View Redirection. | 0 (0=always when available, 1=always when summary data not stale, 2=never)
| DefaultEUL | Sets the EUL you want all users to connect to. Each user can override this default from the Discoverer Plus Options dialog. | Any EUL you have created.
Oracle Applications Mode | AppsGWYUID | Specifies the public username and password for the AOL security DLL. | "APPLSYSPUB/PUB"
| AppsFNDNAM | Specifies the schema in which certain vital Oracle Applications data is stored. | "APPS"
Internal settings | BusinessAreaFastFetchLevel | Controls the amount of pre-caching that occurs for components and items whenever a Business Area is fetched. | 1
| ObjectsAlwaysAccessible | Verify that Business Area objects and items exist in the database. | 0 (0=verify; 1=don't verify and assume that the objects and items exist)
| SummaryObjectsUseCachedAccessibility | Controls whether to access the summary-derived objects in the cache. | 0
| AvoidServerWildcardBug | Set to 1 if running against RDBMS 7.3.2 with NLS_LANG set to Japanese_Japan.JA16SJIS to avoid certain list box appearing empty. | 0
| RdbFastSQLOff |  | 0
Query Prediction and Performance | QPPEnable | Uses query prediction/performance (QPP) if set to 1. | 1 (0 = false, 1 = true)
| QPPCreateNewStats | Records new statistics if set to 1. | 1 (0 = false, 1 = true)
| QPPLoadStatsByObjectUseKey | Records statistics for same objects first if set to 1. | 1 (0 = false, 1 = true)
| QPPUseCpuTime | Query prediction uses CPU time within its algorithm. | 1 (0 = false, 1 = true)
| QPPAvgCostTimeAlgorithm |  | 2
| QPPMaxObjectUseKey | Affects the amount of statistics to cache in memory for query prediction. | 30
| QPPCBOEnforced | Will use cost-based optimizer if set to 1. Will use default optimizer if set to 0. | 1
| QPPObtainCostMethod |  | 1
| QPPMinCost | Only records or uses statistics with a cost greater than this value. | 0
| QPPMaxStats | Only loads this many previous statistics. | 500
| QPPMinActCpuTime | Only records or uses statistics with a CPU time greater than this value. | 0
| QPPMinActElapsedTime | Only records or uses statistics with an actual elapsed time greater than this value. | 0
| QPPMinEstElapsedTime | Only records or uses statistics with an estimated elapsed time greater than this value. | 0
| UseOptimizerHints | Will add optimized hints to SQL if set 1. | 0
| QuerySQLFastFetchLevel |  | 1
| SQLTrace | False (off). | 0
Crosstab Layout | Title | Displays titles that were created in Discoverer 3.1 worksheets. | 1 (0 = no, 1 = yes)
| Cell XGridline | Show horizontal gridlines. | 0 (0 = no, 1 = yes)
| Cell YGridline | Show vertical gridlines. | 0 (0 = no, 1 = yes)
| Axis Style | Crosstab axis position. | 2 (1 = inline, 2 = outline)
Table Layout | Title | Displays titles that were created in Discoverer 3.1 worksheets. | 1 (0 = no, 1 = yes)
| Cell XGridline | Show horizontal gridlines. | 0 (0 = no, 1 = yes)
| Cell YGridline | Show vertical gridlines. | 0 (0 = no, 1 = yes)
| Row Headings | Display row numbers on table worksheets. | 0 (0 = no, 1 = yes)

## C.2 Other Registry settings

#####

Affected Feature | Preference Item Key Name | Description | Default/Values
--- | --- | --- | ---
Locator component | DCW4_START_LOCATOR | Set during install. Determines whether the locator is started or not. | 1 (1, 0)
Preferences, Collector and Session object names. | DCW4_INSTANCE_NAME | Set during install. Discoverer Server Machine name (additional or master machine name). | The host name.
Visigenic object activation daemon. | DCW4_OADPORT | Set during install. The port number as per the Master Discoverer Server. | 5432

## C.3 Low Registry virtual memory quota

Preferences are stored in the Registry on a single machine (the Master Discoverer Server machine). It is possible (but unlikely) that as the number of Discoverer users increases, there will be insufficient virtual memory to increase the size of the Registry. If the Registry size cannot be increased because the system is running low on Registry quota, a warning message appears.

To increase the amount of virtual memory available to the Registry:

1. Select Settings | Control Panel from the Windows Start menu.

2. Select the System program item to display the System Properties dialog.

3. Display the Performance tab of the System Properties dialog and click the Change button to display the Virtual Memory dialog.

4. Increase the value in the Maximum Registry Size (MB) field.

| Copyright © 2000 Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index