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 B

image

The CBO Parameters (11.2.0.1)

SQLT has within it the entire list of parameters that affect your query performance. It uses this list for the XPLORE method. Some parameters are hidden (only sporadically documented in various places) and some are non-hidden (documented in Oracle’s online documentation: database reference manual http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams.htm#i102439 ). You can get this list by issuing the following query from SQLTXPLAIN:

SQL> select name, description from sqlt$_v$parameter_cbo order by name;

The parameter list included in the “Full List of Parameters” section later in this chapter ...

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