@par

This script will give a list of all v$parameter values.  

SQL> @par optim
NAME                                               VALUE
-------------------------------------------------- ---------------------------------------
optimizer_dynamic_sampling                         2 optimizer_features_enable                          10.2.0.4 optimizer_index_caching                            0 optimizer_index_cost_adj                           100 optimizer_mode                                     ALL_ROWS
optimizer_secure_view_merging                      FALSE
SQL>  

  Syntax: @par <partial parameter name>     @par (0 downloads)

Leave a Reply