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 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" |
|
ExcelVersion |
Specifies the version of Excel to export to.
Different versions of Excel impose different limits on the number of rows per sheet:
- the Excel95 limit is 16384 rows per sheet
- the Excel97 limit is 65536 rows per sheet
If the limit is exceeded, Discoverer places the exported rows on a new sheet. |
"Excel95"
("Excel97") |
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) |