Show non-default parameters

Show non-default parameters

set pages 999 lines 100
col name format a30
col value format a50
select  name
, value
from v$parameter
where isdefault = 'FALSE'
and value is not null
order by name
/

Output:

NAME                           VALUE
------------------------------ --------------------------------------------------
_b_tree_bitmap_plans           FALSE
_fast_full_scan_enabled        FALSE
_like_with_bind_as_equality    TRUE
_optimizer_autostats_job       FALSE
_sort_elimination_cost_ratio   5
_sqlexec_progression_cost      2147483647
_system_trig_enabled           TRUE
_trace_files_public            TRUE
aq_tm_processes                1
cluster_database               TRUE
cluster_database_instances     2
compatible                     11.1.0
control_files                  +PRODQA/QA2/controlfile_orq2.dbf
cursor_sharing                 EXACT
db_block_checking              FALSE
db_block_checksum              TRUE
db_block_size                  8192
db_cache_size                  5033164800
db_file_name_convert           +PROD/PROD/datafile/, +PRODQA/QA2/datafile/
db_files                       512
db_name                        QA2
diagnostic_dest                /u2290/app/oracle/product/11.1.0/db_1/admin/QA21_
                               qmnalx1109
dml_locks                      10000
instance_name                  QA21
instance_number                1
java_pool_size                 469762048
job_queue_processes            2
large_pool_size                83886080
local_listener                 QA21_local
log_archive_dest_1             LOCATION=+QA_FRA
log_archive_format             %t_%s_%r.dbf
log_buffer                     10485760
log_checkpoint_interval        100000
log_checkpoint_timeout         1200
log_checkpoints_to_alert       TRUE
log_file_name_convert          +PROD/PROD/onlinelog/, +QA_FRA/QA2/onlinelog/, +PROD_FRA/PROD/onlinelog/, +QA_FRA/QA2/onlinelog/
max_dump_file_size             20480
nls_comp                       binary
nls_date_format                DD-MON-RR
nls_length_semantics           BYTE
nls_numeric_characters         .,
nls_sort                       binary
nls_territory                  america
olap_page_pool_size            4194304
open_cursors                   3000
optimizer_secure_view_merging  FALSE
parallel_max_servers           8
parallel_min_servers           0
pga_aggregate_target           1073741824
processes                      1000
remote_listener                orq2_REMOTE
sec_case_sensitive_logon       FALSE
service_names                  orq2
session_cached_cursors         2800
sessions                       2000
sga_max_size                   8606711808
sga_target                     0
shared_pool_reserved_size      104857600
shared_pool_size               2818572288
spfile                         +PRODQA/QA2/parameterfile/spfile.598.733366761
streams_pool_size              134217728
thread                         1
undo_management                AUTO
undo_tablespace                undots1
utl_file_dir                   /usr/tmp, /usr/tmp, /usr/tmp/QA2, /u2290/app/orac
                               le/product/11.1.0/db_1/appsutil/outbound/QA21_qmn
                               alx1109, /usr/tmp
workarea_size_policy           AUTO
66 rows selected.
Elapsed: 00:00:00.01