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