SELECT name, value FROM v$parameter order by name; NAME VALUE ---------------------------------------------------------------- -------------------------------------------------------------------------------- O7_DICTIONARY_ACCESSIBILITY TRUE always_anti_join NESTED_LOOPS always_semi_join standard aq_tm_processes 0 audit_trail NONE background_dump_dest c:\Oracle\admin\orcl\bdump backup_tape_io_slaves FALSE bitmap_merge_area_size 1048576 blank_trimming FALSE buffer_pool_keep buffer_pool_recycle commit_point_strength 1 compatible 8.1.5.0.0 control_file_record_keep_time 7 control_files c:\Oracle\ORADATA\orcl\control01.ctl, c:\Oracle\ORADATA\orcl\control02.ctl cpu_count 1 create_bitmap_area_size 8388608 cursor_space_for_time FALSE db_block_buffers 200 db_block_checking FALSE db_block_checksum FALSE db_block_lru_latches 1 db_block_max_dirty_target 200 db_block_size 2048 db_domain db_file_direct_io_count 64 db_file_multiblock_read_count 8 db_file_name_convert db_files 1024 db_name o815 db_writer_processes 1 dblink_encrypt_login FALSE dbwr_io_slaves 0 disk_asynch_io FALSE distributed_transactions 18 dml_locks 300 enqueue_resources 1344 ent_domain_name event fast_start_io_target 0 fast_start_parallel_rollback LOW fixed_date gc_defer_time 10 gc_files_to_locks gc_releasable_locks 0 gc_rollback_locks global_names FALSE hash_area_size 131072 hash_join_enabled TRUE hash_multiblock_io_count 0 hi_shared_memory_address 0 hs_autoregister TRUE ifile c:\Oracle\ADMIN\orcl\pfile\init.ora instance_groups instance_name orcl instance_number 0 java_max_sessionspace_size 0 java_pool_size 20971520 java_soft_sessionspace_limit 0 job_queue_interval 60 job_queue_processes 0 large_pool_size 0 license_max_sessions 0 license_max_users 0 license_sessions_warning 0 lm_locks 12000 lm_procs 127 lm_ress 6000 local_listener lock_name_space lock_sga FALSE log_archive_dest log_archive_dest_1 log_archive_dest_2 log_archive_dest_3 log_archive_dest_4 log_archive_dest_5 log_archive_dest_state_1 enable log_archive_dest_state_2 enable log_archive_dest_state_3 enable log_archive_dest_state_4 enable log_archive_dest_state_5 enable log_archive_duplex_dest log_archive_format ARC%S.%T log_archive_max_processes 1 log_archive_min_succeed_dest 1 log_archive_start FALSE log_buffer 8192 log_checkpoint_interval 10000 log_checkpoint_timeout 0 log_checkpoints_to_alert FALSE log_file_name_convert max_commit_propagation_delay 90000 max_dump_file_size 10240 max_enabled_roles 20 max_rollback_segments 30 mts_dispatchers mts_listener_address mts_max_dispatchers 5 mts_max_servers 20 mts_multiple_listeners FALSE mts_servers 0 mts_service o815 nls_calendar nls_comp nls_currency nls_date_format nls_date_language nls_dual_currency nls_iso_currency nls_language AMERICAN nls_numeric_characters nls_sort nls_territory AMERICA nls_time_format nls_time_tz_format nls_timestamp_format nls_timestamp_tz_format object_cache_max_size_percent 10 object_cache_optimal_size 102400 open_cursors 50 open_links 4 open_links_per_instance 4 optimizer_features_enable 8.1.5 optimizer_index_caching 0 optimizer_index_cost_adj 100 optimizer_max_permutations 80000 optimizer_mode CHOOSE optimizer_percent_parallel 0 optimizer_search_limit 5 oracle_trace_collection_name oracle8 oracle_trace_collection_path %ORACLE_HOME%\OTRACE\ADMIN\CDF\ oracle_trace_collection_size 5242880 oracle_trace_enable FALSE oracle_trace_facility_name oracled oracle_trace_facility_path %ORACLE_HOME%\OTRACE\ADMIN\FDF\ os_authent_prefix OPS$ os_roles FALSE parallel_adaptive_multi_user FALSE parallel_automatic_tuning FALSE parallel_broadcast_enabled FALSE parallel_execution_message_size 2148 parallel_instance_group parallel_max_servers 5 parallel_min_percent 0 parallel_min_servers 0 parallel_server FALSE parallel_server_instances 1 parallel_threads_per_cpu 2 partition_view_enabled FALSE plsql_load_without_compile FALSE plsql_v2_compatibility FALSE pre_page_sga FALSE processes 59 query_rewrite_enabled FALSE query_rewrite_integrity enforced rdbms_server_dn read_only_open_delayed FALSE recovery_parallelism 0 remote_dependencies_mode TIMESTAMP remote_login_passwordfile SHARED remote_os_authent FALSE remote_os_roles FALSE replication_dependency_tracking TRUE resource_limit FALSE resource_manager_plan rollback_segments row_locking always serial_reuse DISABLE serializable FALSE service_names o815 session_cached_cursors 0 session_max_open_files 10 sessions 69 shared_memory_address 0 shared_pool_reserved_size 786432 shared_pool_size 15728640 sort_area_retained_size 0 sort_area_size 65536 sort_multiblock_read_count 2 sql92_security FALSE sql_trace FALSE standby_archive_dest %ORACLE_HOME%\RDBMS star_transformation_enabled FALSE tape_asynch_io TRUE text_enable FALSE thread 0 timed_os_statistics 0 timed_statistics FALSE transaction_auditing TRUE transactions 75 transactions_per_rollback_segment 5 use_indirect_data_buffers FALSE user_dump_dest c:\Oracle\admin\orcl\udump utl_file_dir