The CBO Parameters (18.104.22.168)
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 ...