APPENDIX C

image

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.