APPENDIX C
Tool Configuration Parameters
This appendix includes all the tool configuration parameters and their descriptions.
Parameter | Description |
automatic_workload_repository | Access to the Automatic Workload Repository (AWR) requires a license for the Oracle Diagnostic Pack. If you don’t have it you can set this parameter to N. |
bde_chk_cbo | On EBS applications SQLT automatically executes bde_chk_cbo.sql from Note:174605.1. |
c_cbo_stats_vers_days | Days of CBO statistics versions to be collected. If set to 0 no statistics versions are collected. If set to a value larger than actual stored days, then SQLT collects the whole history. A ... |
Get Oracle SQL Tuning with Oracle SQLTXPLAIN now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.