Page History
...
The following table describes the configurable process parameters and default values in the Oracle Collect Bind Variables process.
Table 7-7 Configurable 7 Configurable process parameters and their default valuesParameter Default
Parameter | Default value |
---|---|
Maximum number of statements to collect binds for: |
...
20 |
...
|
...
| |
Maximum number of bind sets per statement to collect: |
...
3 |
...
|
...
| |
List of mandatory statements to collect binds for: |
...
No default value |
About the Oracle Collect Instance Statistics process parameters
The Oracle Collect Instance Statistics process collects segment statistics. If you decide not to collect segment statistics, no active objects are displayed in the Objects tab.
The following table describes the configurable process parameters and default values in the Oracle Collect Instance Statistics process.
Table 7-8 Configurable 8 Configurable process parameters and their default values
Parameter |
---|
...
...
Default value |
---|
Collect segment statistics every n |
...
hours | 4
|
|
...
| |
Maximum number of segments to collect |
...
n | 500 |
List of mandatory segments n (such as |
...
EMP_TBL, EMP_DETP_IDX) |
...
No default value |
About the Oracle Explain Statements process parameters
The Oracle Explain Statements process automatically explains the top n statements and parses the statements that were explained. By default, this process is run once a night.
The following table describes the configurable process parameters and default values in the Oracle Explain Statements process.
Table 7-9 Configurable 9 Configurable process parameters and their default valuesParameter Default
Parameter | Default value |
---|---|
Explain only Top-N Statements (based on their In Oracle time) |
...
1000 | |
Parse Top-N Statements (based on their In Oracle time) |
...
1000 | |
Timeout if Explain takes more than n |
...
seconds | 60 |
Save the last n Explain plans for each explained |
...
statement | 3 |
About
...
the Oracle Load Data process parameters
The following table describes the configurable process parameter and default value in the Oracle Load Data process.
Table 7-10 Configurable 10 Configurable process parameter and its default value
Parameter |
---|
...
Default value |
---|
Load only Top-N Programs |
...
information | 300 |
Load only Top-N Statements |
...
information | 500 |
Load only Top-N Objects |
...
information | 700 |
About the Oracle Object Statistics Changes process parameters
The following table describes the configurable process parameters and default values in the Oracle Object Statistics Changes process.
Table 7-11 Configurable 11 Configurable process parameters and their default values
Parameter |
---|
...
Default value |
---|
Keep track on changes in column |
...
statistics | Cleared |
Collect database size statistics every n |
...
days | 1 |
About the Oracle Perform SmarTune Analysis on Changes process parameter
The following table describes the configurable process parameter and default value in the Oracle Perform SmarTune Analysis on Changes process.
Table 7-12 Configurable 12 Configurable process parameter and its default value
Parameter |
---|
...
Default value |
---|
Analyze the impact of changes in the last n |
...
days | 30 |
About the Oracle Purge Data process parameters
The following table describes the configurable process parameters and default values in the Oracle Purge Data process.
Table 7-13 Configurable 13 Configurable process parameters and their default values
Parameter |
---|
...
Default value |
---|
Purge schema changes data older than n |
...
weeks | 52 |
Purge database structure data older than n |
...
weeks | 26 |
About the Oracle Real Execution Plans process parameter
The Oracle Real Execution Plans process collects real execution plans stored in Oracle (applicable for Oracle 9i and later) system tables. If this process is not run, no real execution plan information is displayed in the SQL tab. By default, this process is run once an hour.
The following table describes the configurable process parameter and default values in the Oracle Actual Execution Plans process.
Table 7-14 Configurable 14 Configurable process parameter and its default value
Parameter |
---|
...
Default value |
---|
Maximum number of statements to collect actual execution plans |
...
...
for | 500
|
...
About the Oracle Applications Load Data process parameters
The following table describes the configurable process parameter and default value in the Oracle Applications Load Data process.
...