Oracle Parameter info
set termout off store set sqlplus_settings replace set serveroutput on size 1000000 linesize 132 pagesize 120 termout off verify off head off ttitle off btitle off clear columns clear breaks column param_name format a40 heading "Parameter Name" column param_value format a38 heading "Parameter Value" word_wrap column isdefault format a7 heading "Default|Value" column ismod heading "Is|Modified" column isses_modifiable format a10 heading "Session|Modifiable" column issys_modifiable format a10 heading "System|Modifiable" -- Get database name and store in variable column name new_value s_dbname SELECT rtrim(name) name from v$database; -- Get today's date column today new_value s_curDate SELECT to_char(sysdate, 'Month DD, YYYY') today from dual; -- Get host name and store in variable column host_name new_value s_machine SELECT host_name from v$instance; set termout feedback off head on spool databaseParametersInfo_&s_dbname._&s_machine ttitle left &s_curDate - center "List of Database Parameters in Instance " &s_dbname " on " &s_machine skip 2 select name param_name, value param_value, isdefault, ismodified ismod, isses_modifiable, issys_modifiable from v$parameter where value is not null order by param_name; spool off ttitle off btitle off clear columns clear breaks set feedback on termout on verify on List of Database Parameters in Instance VIHAAN on ora-gold1 Default Is Session System Parameter Name Parameter Value Value Modified Modifiable Modifiable ---------------------------------------- -------------------------------------- ------- ---------- ---------- ---------- DBFIPS_140 FALSE TRUE FALSE FALSE FALSE O7_DICTIONARY_ACCESSIBILITY FALSE TRUE FALSE FALSE FALSE aq_tm_processes 1 TRUE FALSE FALSE IMMEDIATE archive_lag_target 0 FALSE FALSE FALSE IMMEDIATE asm_power_limit 1 TRUE FALSE TRUE IMMEDIATE audit_file_dest /u01/app/oracle/admin/vihaan/adump FALSE FALSE FALSE DEFERRED audit_sys_operations TRUE TRUE FALSE FALSE FALSE audit_trail DB FALSE FALSE FALSE FALSE awr_snapshot_time_offset 0 TRUE FALSE FALSE IMMEDIATE background_core_dump partial TRUE FALSE FALSE FALSE background_dump_dest /u01/app/oracle/product/12.1.0/db_1/rd TRUE FALSE FALSE IMMEDIATE bms/log backup_tape_io_slaves FALSE TRUE FALSE FALSE DEFERRED bitmap_merge_area_size 1048576 TRUE FALSE FALSE FALSE blank_trimming FALSE TRUE FALSE FALSE FALSE cell_offload_compaction ADAPTIVE TRUE FALSE TRUE IMMEDIATE cell_offload_decryption TRUE TRUE FALSE FALSE IMMEDIATE cell_offload_plan_display AUTO TRUE FALSE TRUE IMMEDIATE cell_offload_processing TRUE TRUE FALSE TRUE IMMEDIATE client_result_cache_lag 3000 TRUE FALSE FALSE FALSE client_result_cache_size 0 TRUE FALSE FALSE FALSE clonedb FALSE TRUE FALSE FALSE FALSE cluster_database FALSE TRUE FALSE FALSE FALSE cluster_database_instances 1 TRUE FALSE FALSE FALSE commit_point_strength 1 TRUE FALSE FALSE FALSE common_user_prefix C## TRUE FALSE FALSE FALSE compatible 12.1.0.2.0 FALSE FALSE FALSE FALSE connection_brokers ((TYPE=DEDICATED)(BROKERS=1)), TRUE FALSE FALSE IMMEDIATE ((TYPE=EMON)(BROKERS=1)) control_file_record_keep_time 7 TRUE FALSE FALSE IMMEDIATE control_files /u01/app/oracle/oradata/VIHAAN/control FALSE FALSE FALSE FALSE file/o1_mf_b282tp9s_.ctl, /u01/app/oracle/fast_recovery_area/VIH AAN/controlfile/o1_mf_b282tpl6_.ctl control_management_pack_access DIAGNOSTIC+TUNING TRUE FALSE FALSE IMMEDIATE core_dump_dest /u01/app/oracle/diag/rdbms/vihaan_prim TRUE FALSE FALSE IMMEDIATE /vihaan/cdump cpu_count 1 TRUE FALSE FALSE IMMEDIATE create_bitmap_area_size 8388608 TRUE FALSE FALSE FALSE cursor_bind_capture_destination memory+disk TRUE FALSE TRUE IMMEDIATE cursor_sharing EXACT TRUE FALSE TRUE IMMEDIATE cursor_space_for_time FALSE TRUE FALSE FALSE FALSE db_16k_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_2k_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_32k_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_4k_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_8k_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_big_table_cache_percent_target 0 TRUE FALSE FALSE IMMEDIATE db_block_buffers 0 TRUE FALSE FALSE FALSE db_block_checking FALSE TRUE FALSE FALSE IMMEDIATE db_block_checksum TYPICAL TRUE FALSE FALSE IMMEDIATE db_block_size 8192 FALSE FALSE FALSE FALSE db_cache_advice ON TRUE FALSE FALSE IMMEDIATE db_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_create_file_dest /u01/app/oracle/oradata FALSE FALSE TRUE IMMEDIATE db_file_multiblock_read_count 53 TRUE FALSE TRUE IMMEDIATE db_files 200 TRUE FALSE FALSE FALSE db_flash_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_flashback_retention_target 1440 TRUE FALSE FALSE IMMEDIATE db_index_compression_inheritance NONE TRUE FALSE TRUE IMMEDIATE db_keep_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_lost_write_protect NONE TRUE FALSE FALSE IMMEDIATE db_name vihaan FALSE FALSE FALSE FALSE db_recovery_file_dest /u01/app/oracle/fast_recovery_area FALSE FALSE FALSE IMMEDIATE db_recovery_file_dest_size 4781506560 FALSE FALSE FALSE IMMEDIATE db_recycle_cache_size 0 TRUE FALSE FALSE IMMEDIATE db_securefile PREFERRED TRUE FALSE TRUE IMMEDIATE db_ultra_safe OFF TRUE FALSE FALSE FALSE db_unique_name vihaan_prim FALSE FALSE FALSE FALSE db_unrecoverable_scn_tracking TRUE TRUE FALSE TRUE IMMEDIATE db_writer_processes 1 TRUE FALSE FALSE FALSE dbwr_io_slaves 0 TRUE FALSE FALSE FALSE ddl_lock_timeout 0 TRUE FALSE TRUE IMMEDIATE deferred_segment_creation TRUE TRUE FALSE TRUE IMMEDIATE dg_broker_config_file1 /u01/app/oracle/product/12.1.0/db_1/db TRUE FALSE FALSE IMMEDIATE s/dr1vihaan_prim.dat dg_broker_config_file2 /u01/app/oracle/product/12.1.0/db_1/db TRUE FALSE FALSE IMMEDIATE s/dr2vihaan_prim.dat dg_broker_start TRUE FALSE FALSE FALSE IMMEDIATE diagnostic_dest /u01/app/oracle FALSE FALSE FALSE IMMEDIATE disk_asynch_io TRUE TRUE FALSE FALSE FALSE dispatchers (PROTOCOL=TCP) (SERVICE=vihaanXDB) FALSE FALSE FALSE IMMEDIATE distributed_lock_timeout 60 TRUE FALSE FALSE FALSE dml_locks 2076 TRUE FALSE FALSE FALSE dnfs_batch_size 4096 TRUE FALSE FALSE FALSE dst_upgrade_insert_conv TRUE TRUE FALSE TRUE IMMEDIATE enable_ddl_logging FALSE TRUE FALSE TRUE IMMEDIATE enable_goldengate_replication FALSE TRUE FALSE FALSE IMMEDIATE enable_pluggable_database FALSE TRUE FALSE FALSE FALSE exclude_seed_cdb_view TRUE TRUE FALSE TRUE IMMEDIATE fal_client (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P FALSE FALSE FALSE IMMEDIATE ROTOCOL=TCP)(HOST=192.168.0.27)(PORT=1 521)))(CONNECT_DATA=(SERVICE_NAME=viha an_prim)(INSTANCE_NAME=vihaan)(SERVER= dedicated))) fal_server NULL FALSE FALSE FALSE IMMEDIATE fast_start_io_target 0 TRUE FALSE FALSE IMMEDIATE fast_start_mttr_target 0 TRUE FALSE FALSE IMMEDIATE fast_start_parallel_rollback LOW TRUE FALSE FALSE IMMEDIATE file_mapping FALSE TRUE FALSE FALSE IMMEDIATE filesystemio_options none TRUE FALSE FALSE FALSE gcs_server_processes 0 TRUE FALSE FALSE FALSE global_names FALSE TRUE FALSE TRUE IMMEDIATE global_txn_processes 1 TRUE FALSE FALSE IMMEDIATE hash_area_size 131072 TRUE FALSE TRUE FALSE heat_map OFF TRUE FALSE TRUE IMMEDIATE hi_shared_memory_address 0 TRUE FALSE FALSE FALSE hs_autoregister TRUE TRUE FALSE FALSE IMMEDIATE inmemory_force DEFAULT TRUE FALSE FALSE IMMEDIATE inmemory_max_populate_servers 0 TRUE FALSE FALSE IMMEDIATE inmemory_query DISABLE FALSE FALSE TRUE IMMEDIATE inmemory_size 0 TRUE FALSE FALSE IMMEDIATE inmemory_trickle_repopulate_servers_perc 1 TRUE FALSE FALSE IMMEDIATE ent instance_name vihaan TRUE FALSE FALSE FALSE instance_number 0 TRUE FALSE FALSE FALSE instance_type RDBMS TRUE FALSE FALSE FALSE instant_restore FALSE TRUE FALSE FALSE FALSE java_jit_enabled TRUE TRUE FALSE TRUE IMMEDIATE java_max_sessionspace_size 0 TRUE FALSE FALSE FALSE java_pool_size 0 TRUE FALSE FALSE IMMEDIATE java_restrict none TRUE FALSE FALSE FALSE java_soft_sessionspace_limit 0 TRUE FALSE FALSE FALSE job_queue_processes 1000 TRUE FALSE FALSE IMMEDIATE large_pool_size 0 TRUE FALSE FALSE IMMEDIATE ldap_directory_access NONE TRUE FALSE FALSE IMMEDIATE ldap_directory_sysauth no TRUE FALSE FALSE FALSE license_max_sessions 0 TRUE FALSE FALSE IMMEDIATE license_max_users 0 TRUE FALSE FALSE IMMEDIATE license_sessions_warning 0 TRUE FALSE FALSE IMMEDIATE local_listener (ADDRESS_LIST = (ADDRESS = (PROTOCOL = FALSE FALSE FALSE IMMEDIATE TCP)(HOST = 192.168.0.27)(PORT = 1521))) lock_sga FALSE TRUE FALSE FALSE FALSE log_archive_config DG_CONFIG=(vihaan_prim, vihaan_stdy) FALSE FALSE FALSE IMMEDIATE log_archive_dest_1 location=/u01/app/oracle/ArchiveLog FALSE FALSE TRUE IMMEDIATE log_archive_dest_2 service="stdy1", ASYNC NOAFFIRM FALSE FALSE TRUE IMMEDIATE delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="vihaan_stdy" net_timeout=30, valid_for=(online_logfile,all_roles) log_archive_dest_state_1 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_10 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_11 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_12 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_13 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_14 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_15 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_16 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_17 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_18 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_19 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_2 RESET FALSE FALSE TRUE IMMEDIATE log_archive_dest_state_20 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_21 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_22 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_23 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_24 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_25 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_26 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_27 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_28 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_29 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_3 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_30 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_31 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_4 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_5 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_6 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_7 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_8 enable TRUE FALSE TRUE IMMEDIATE log_archive_dest_state_9 enable TRUE FALSE TRUE IMMEDIATE log_archive_format Log%s_%t_%r.Arc FALSE FALSE FALSE FALSE log_archive_max_processes 4 FALSE FALSE FALSE IMMEDIATE log_archive_min_succeed_dest 1 FALSE FALSE TRUE IMMEDIATE log_archive_start FALSE TRUE FALSE FALSE FALSE log_archive_trace 0 FALSE SYSTEM_MOD FALSE IMMEDIATE log_buffer 5193728 TRUE FALSE FALSE FALSE log_checkpoint_interval 0 TRUE FALSE FALSE IMMEDIATE log_checkpoint_timeout 1800 TRUE FALSE FALSE IMMEDIATE log_checkpoints_to_alert FALSE TRUE FALSE FALSE IMMEDIATE max_dump_file_size unlimited TRUE FALSE TRUE IMMEDIATE max_enabled_roles 150 TRUE FALSE FALSE FALSE max_string_size STANDARD TRUE FALSE FALSE IMMEDIATE memory_max_target 0 TRUE FALSE FALSE FALSE memory_target 0 TRUE FALSE FALSE IMMEDIATE nls_comp BINARY TRUE FALSE TRUE FALSE nls_date_format DD-MON HH24:MI TRUE MODIFIED TRUE FALSE nls_language AMERICAN TRUE FALSE TRUE FALSE nls_length_semantics BYTE TRUE FALSE TRUE IMMEDIATE nls_nchar_conv_excp FALSE TRUE FALSE TRUE IMMEDIATE nls_territory AMERICA TRUE FALSE TRUE FALSE noncdb_compatible FALSE TRUE FALSE FALSE FALSE object_cache_max_size_percent 10 TRUE FALSE TRUE DEFERRED object_cache_optimal_size 102400 TRUE FALSE TRUE DEFERRED olap_page_pool_size 0 TRUE FALSE TRUE DEFERRED open_cursors 300 FALSE FALSE FALSE IMMEDIATE open_links 4 TRUE FALSE FALSE FALSE open_links_per_instance 4 TRUE FALSE FALSE FALSE optimizer_adaptive_features TRUE TRUE FALSE TRUE IMMEDIATE optimizer_adaptive_reporting_only FALSE TRUE FALSE TRUE IMMEDIATE optimizer_capture_sql_plan_baselines FALSE TRUE FALSE TRUE IMMEDIATE optimizer_dynamic_sampling 2 TRUE FALSE TRUE IMMEDIATE optimizer_features_enable 12.1.0.2 TRUE FALSE TRUE IMMEDIATE optimizer_index_caching 0 TRUE FALSE TRUE IMMEDIATE optimizer_index_cost_adj 100 TRUE FALSE TRUE IMMEDIATE optimizer_inmemory_aware TRUE TRUE FALSE TRUE IMMEDIATE optimizer_mode ALL_ROWS TRUE FALSE TRUE IMMEDIATE optimizer_secure_view_merging TRUE TRUE FALSE FALSE IMMEDIATE optimizer_use_invisible_indexes FALSE TRUE FALSE TRUE IMMEDIATE optimizer_use_pending_statistics FALSE TRUE FALSE TRUE IMMEDIATE optimizer_use_sql_plan_baselines TRUE TRUE FALSE TRUE IMMEDIATE os_authent_prefix ops$ TRUE FALSE FALSE FALSE os_roles FALSE TRUE FALSE FALSE FALSE parallel_adaptive_multi_user TRUE TRUE FALSE FALSE IMMEDIATE parallel_automatic_tuning FALSE TRUE FALSE FALSE FALSE parallel_degree_level 100 TRUE FALSE TRUE IMMEDIATE parallel_degree_limit CPU TRUE FALSE TRUE IMMEDIATE parallel_degree_policy MANUAL TRUE FALSE TRUE IMMEDIATE parallel_execution_message_size 16384 TRUE FALSE FALSE FALSE parallel_force_local FALSE TRUE FALSE TRUE IMMEDIATE parallel_io_cap_enabled FALSE TRUE FALSE TRUE IMMEDIATE parallel_max_servers 40 TRUE FALSE FALSE IMMEDIATE parallel_min_percent 0 TRUE FALSE TRUE FALSE parallel_min_servers 4 TRUE FALSE FALSE IMMEDIATE parallel_min_time_threshold AUTO TRUE FALSE TRUE IMMEDIATE parallel_server FALSE TRUE FALSE FALSE FALSE parallel_server_instances 1 TRUE FALSE FALSE FALSE parallel_servers_target 16 TRUE FALSE FALSE IMMEDIATE parallel_threads_per_cpu 2 TRUE FALSE FALSE IMMEDIATE permit_92_wrap_format TRUE TRUE FALSE FALSE FALSE pga_aggregate_limit 2147483648 TRUE FALSE FALSE IMMEDIATE pga_aggregate_target 152043520 FALSE FALSE FALSE IMMEDIATE plscope_settings IDENTIFIERS:NONE TRUE FALSE TRUE IMMEDIATE plsql_code_type INTERPRETED TRUE FALSE TRUE IMMEDIATE plsql_debug FALSE TRUE FALSE TRUE IMMEDIATE plsql_optimize_level 2 TRUE FALSE TRUE IMMEDIATE plsql_v2_compatibility FALSE TRUE FALSE TRUE IMMEDIATE plsql_warnings DISABLE:ALL TRUE FALSE TRUE IMMEDIATE pre_page_sga TRUE TRUE FALSE FALSE FALSE processes 300 FALSE FALSE FALSE FALSE query_rewrite_enabled TRUE TRUE FALSE TRUE IMMEDIATE query_rewrite_integrity enforced TRUE FALSE TRUE IMMEDIATE read_only_open_delayed FALSE TRUE FALSE FALSE FALSE recovery_parallelism 0 TRUE FALSE FALSE FALSE recyclebin OFF FALSE FALSE TRUE DEFERRED remote_dependencies_mode TIMESTAMP TRUE FALSE TRUE IMMEDIATE remote_login_passwordfile EXCLUSIVE FALSE FALSE FALSE FALSE remote_os_authent FALSE TRUE FALSE FALSE FALSE remote_os_roles FALSE TRUE FALSE FALSE FALSE replication_dependency_tracking TRUE TRUE FALSE FALSE FALSE resource_limit TRUE TRUE FALSE FALSE IMMEDIATE resource_manager_cpu_allocation 1 TRUE FALSE FALSE IMMEDIATE resource_manager_plan SCHEDULER[0x4448]:DEFAULT_MAINTENANCE_ TRUE FALSE FALSE IMMEDIATE PLAN result_cache_max_result 5 TRUE FALSE FALSE IMMEDIATE result_cache_max_size 2293760 TRUE FALSE FALSE IMMEDIATE result_cache_mode MANUAL TRUE FALSE TRUE IMMEDIATE result_cache_remote_expiration 0 TRUE FALSE TRUE IMMEDIATE resumable_timeout 0 TRUE FALSE TRUE IMMEDIATE sec_case_sensitive_logon TRUE TRUE FALSE FALSE IMMEDIATE sec_max_failed_login_attempts 3 TRUE FALSE FALSE FALSE sec_protocol_error_further_action (DROP,3) TRUE FALSE FALSE IMMEDIATE sec_protocol_error_trace_action TRACE TRUE FALSE FALSE IMMEDIATE sec_return_server_release_banner FALSE TRUE FALSE FALSE FALSE serial_reuse disable TRUE FALSE FALSE FALSE service_names VIHAAN1, VIHAAN2 FALSE FALSE FALSE IMMEDIATE session_cached_cursors 50 TRUE FALSE TRUE FALSE session_max_open_files 10 TRUE FALSE FALSE FALSE sessions 472 TRUE FALSE FALSE IMMEDIATE sga_max_size 457179136 TRUE FALSE FALSE FALSE sga_target 457179136 FALSE FALSE FALSE IMMEDIATE shadow_core_dump partial TRUE FALSE FALSE FALSE shared_memory_address 0 TRUE FALSE FALSE FALSE shared_pool_reserved_size 5033164 TRUE FALSE FALSE FALSE shared_pool_size 0 TRUE FALSE FALSE IMMEDIATE shared_servers 1 TRUE FALSE FALSE IMMEDIATE skip_unusable_indexes TRUE TRUE FALSE TRUE IMMEDIATE sort_area_retained_size 0 TRUE FALSE TRUE DEFERRED sort_area_size 65536 TRUE FALSE TRUE DEFERRED spatial_vector_acceleration FALSE TRUE FALSE TRUE IMMEDIATE spfile /u01/app/oracle/product/12.1.0/db_1/db TRUE FALSE FALSE IMMEDIATE s/spfilevihaan.ora sql92_security FALSE TRUE FALSE FALSE FALSE sql_trace FALSE TRUE FALSE TRUE IMMEDIATE sqltune_category DEFAULT TRUE FALSE TRUE IMMEDIATE standby_archive_dest ?/dbs/arch TRUE FALSE FALSE IMMEDIATE standby_file_management MANUAL FALSE FALSE FALSE IMMEDIATE star_transformation_enabled FALSE TRUE FALSE TRUE IMMEDIATE statistics_level TYPICAL TRUE FALSE TRUE IMMEDIATE streams_pool_size 0 TRUE FALSE FALSE IMMEDIATE tape_asynch_io TRUE TRUE FALSE FALSE FALSE temp_undo_enabled FALSE TRUE FALSE TRUE IMMEDIATE thread 0 TRUE FALSE FALSE IMMEDIATE threaded_execution FALSE TRUE FALSE FALSE FALSE timed_os_statistics 0 TRUE FALSE TRUE IMMEDIATE timed_statistics TRUE TRUE FALSE TRUE IMMEDIATE trace_enabled TRUE TRUE FALSE FALSE IMMEDIATE transactions 519 TRUE FALSE FALSE FALSE transactions_per_rollback_segment 5 TRUE FALSE FALSE FALSE undo_management AUTO TRUE FALSE FALSE FALSE undo_retention 900 TRUE FALSE FALSE IMMEDIATE undo_tablespace UNDOTBS1 FALSE FALSE FALSE IMMEDIATE unified_audit_sga_queue_size 1048576 TRUE FALSE FALSE FALSE use_dedicated_broker FALSE TRUE FALSE FALSE IMMEDIATE use_indirect_data_buffers FALSE TRUE FALSE FALSE FALSE use_large_pages TRUE TRUE FALSE FALSE FALSE user_dump_dest /u01/app/oracle/product/12.1.0/db_1/rd TRUE FALSE FALSE IMMEDIATE bms/log workarea_size_policy AUTO TRUE FALSE TRUE IMMEDIATE xml_db_events enable TRUE FALSE TRUE IMMEDIATE 289 rows selected.
Saturday, 8 November 2014
Oracle Parameter info
Subscribe to:
Post Comments (Atom)
1 comment:
SET PAUSE ON PAUSE 'Press Return to Continue.... '
SET PAGESIZE 300 LINESIZE 300
COLUMN name FORMAT A40
COLUMN value FORMAT A70
COLUMN ses_mod FORMAT a10
COLUMN sys_mod FORMAT a10
COLUMN ins_mod FORMAT a10
SELECT p.name,
p.type,
p.value,
p.isses_modifiable as SES_MOD,
p.issys_modifiable as SYS_MOD,
p.isinstance_modifiable as INS_MOD
FROM v$parameter p
where 1=1
and p.value is not null
ORDER BY p.name
/
Post a Comment