Oracle Discoverer 4i Configuration Guide for Oracle9i Application Server Release 4.1 for UNIX A87572-01 |
Library | Service | Contents | Index

# C
Discoverer 4i Preference Settings

## C.1 Preference settings in pref.txt

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

#####

Affected Feature | Preference Item 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. |
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)

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