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>
Download: sql4oracle.zip - all sql4oracle scripts - posted 14-03-2013