O'Reilly logo

Oracle SQL Tuning with Oracle SQLTXPLAIN by Stelios Charalambides

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required