select * from V$PARAMETER

NUM | NAME | TYPE | VALUE | ISDEFAULT | ISSES_MODIFIABLE | ISSYS_MODIFIABLE | ISMODIFIED | ISADJUSTED | DESCRIPTION | UPDATE_COMMENT
2 | tracefile_identifier | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | trace file custom identifier | null
18 | processes | 3 | 200 | FALSE | FALSE | FALSE | FALSE | FALSE | user processes | null
20 | sessions | 3 | 225 | TRUE | FALSE | FALSE | FALSE | FALSE | user and system sessions | null
21 | timed_statistics | 1 | TRUE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | maintain internal timing statistics | null
22 | timed_os_statistics | 3 | 0 | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | internal os statistic gathering interval in seconds | null
23 | resource_limit | 1 | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | master switch for resource limit | null
24 | license_max_sessions | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | maximum number of non-system user sessions allowed | null
25 | license_sessions_warning | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | warning level for number of non-system user sessions | null
33 | cpu_count | 3 | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | initial number of cpu's for this instance | null
36 | instance_groups | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | list of instance group names | null
37 | event | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | debug event control - default null string | null
44 | shared_pool_size | 6 | 109051904 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | size in bytes of shared pool | null
45 | sga_max_size | 6 | 372629652 | FALSE | FALSE | FALSE | FALSE | FALSE | max total SGA size | internally adjusted
49 | shared_pool_reserved_size | 6 | 5452595 | TRUE | FALSE | FALSE | FALSE | FALSE | size in bytes of reserved area of shared pool | null
52 | large_pool_size | 6 | 16777216 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | size in bytes of the large allocation pool | null
54 | java_pool_size | 6 | 16777216 | FALSE | FALSE | FALSE | FALSE | FALSE | size in bytes of the Java pool | null
55 | java_soft_sessionspace_limit | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | warning limit on size in bytes of a Java sessionspace | null
56 | java_max_sessionspace_size | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | max allowed size in bytes of a Java sessionspace | null
57 | pre_page_sga | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | pre-page sga for process | null
58 | shared_memory_address | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | SGA starting address (low order 32-bits on 64-bit platforms) | null
59 | hi_shared_memory_address | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | SGA starting address (high order 32-bits on 64-bit platforms) | null
60 | use_indirect_data_buffers | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Enable indirect data buffers (very large SGA on 32-bit platforms | null
62 | lock_sga | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Lock entire SGA in physical memory | null
77 | spfile | 2 | %ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA | TRUE | FALSE | FALSE | FALSE | FALSE | server parameter file | null
81 | lock_name_space | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | lock name space used for generating lock names for standby/clone | null
83 | enqueue_resources | 3 | 1104 | TRUE | FALSE | FALSE | FALSE | FALSE | resources for enqueues | null
88 | trace_enabled | 1 | TRUE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | enable KST tracing | null
96 | nls_language | 2 | AMERICAN | TRUE | TRUE | FALSE | FALSE | FALSE | NLS language name | null
97 | nls_territory | 2 | AMERICA | TRUE | TRUE | FALSE | FALSE | FALSE | NLS territory name | null
98 | nls_sort | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS linguistic definition name | null
99 | nls_date_language | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS date language name | null
100 | nls_date_format | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS Oracle date format | null
101 | nls_currency | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS local currency symbol | null
102 | nls_numeric_characters | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS numeric characters | null
103 | nls_iso_currency | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS ISO currency territory name | null
104 | nls_calendar | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS calendar system name | null
105 | nls_time_format | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | time format | null
106 | nls_timestamp_format | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | time stamp format | null
107 | nls_time_tz_format | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | time with timezone format | null
108 | nls_timestamp_tz_format | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | timestampe with timezone format | null
109 | nls_dual_currency | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | Dual currency symbol | null
110 | nls_comp | 2 | null | TRUE | TRUE | FALSE | FALSE | FALSE | NLS comparison | null
111 | nls_length_semantics | 2 | BYTE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | create columns using byte or char semantics by default | null
112 | nls_nchar_conv_excp | 2 | FALSE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | NLS raise an exception instead of allowing implicit conversion | null
120 | filesystemio_options | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | IO operations on filesystem files | null
124 | disk_asynch_io | 1 | TRUE | TRUE | FALSE | FALSE | FALSE | FALSE | Use asynch I/O for random access devices | null
125 | tape_asynch_io | 1 | TRUE | TRUE | FALSE | FALSE | FALSE | FALSE | Use asynch I/O requests for tape devices | null
127 | dbwr_io_slaves | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | DBWR I/O slaves | null
131 | backup_tape_io_slaves | 1 | FALSE | TRUE | FALSE | DEFERRED | FALSE | FALSE | BACKUP Tape I/O slaves | null
135 | resource_manager_plan | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | resource mgr top plan | null
144 | cluster_interconnects | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | interconnects for RAC use | null
147 | file_mapping | 1 | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | enable file mapping | null
165 | active_instance_count | 3 | null | TRUE | FALSE | FALSE | FALSE | FALSE | number of active instances in the cluster database | null
228 | control_files | 2 | D:\wt\ocu_8.0\oradata\wind\CTRL1_wind.CTL, D:\wt\ocu_8.0\oradata\wind\CTRL2_wind.CTL | FALSE | FALSE | FALSE | FALSE | FALSE | control file names list | null
230 | db_file_name_convert | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | datafile name convert patterns and strings for standby/clone db | null
231 | log_file_name_convert | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | logfile name convert patterns and strings for standby/clone db | null
232 | db_block_buffers | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | Number of database blocks cached in memory | null
235 | db_block_checksum | 1 | TRUE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | store checksum in db blocks and check during reads | null
236 | db_block_size | 3 | 16384 | FALSE | FALSE | FALSE | FALSE | FALSE | Size of database block in bytes | null
243 | db_writer_processes | 3 | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | number of background database writer processes to start | null
256 | db_keep_cache_size | 6 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Size of KEEP buffer pool for standard block size buffers | null
257 | db_recycle_cache_size | 6 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Size of RECYCLE buffer pool for standard block size buffers | null
258 | db_2k_cache_size | 6 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Size of cache for 2K buffers | null
259 | db_4k_cache_size | 6 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Size of cache for 4K buffers | null
260 | db_8k_cache_size | 6 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Size of cache for 8K buffers | null
261 | db_16k_cache_size | 6 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Size of cache for 16K buffers | null
262 | db_32k_cache_size | 6 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Size of cache for 32K buffers | null
263 | db_cache_size | 6 | 209715200 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | Size of DEFAULT buffer pool for standard block size buffers | null
265 | buffer_pool_keep | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | Number of database blocks/latches in keep buffer pool | null
266 | buffer_pool_recycle | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | Number of database blocks/latches in recycle buffer pool | null
293 | db_cache_advice | 2 | ON | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Buffer cache sizing advisory | null
302 | max_commit_propagation_delay | 3 | 700 | TRUE | FALSE | FALSE | FALSE | FALSE | Max age of new snapshot in .01 seconds | null
304 | compatible | 2 | 9.2.0 | FALSE | FALSE | FALSE | FALSE | FALSE | Database will be completely compatible with this software versio | null
310 | remote_archive_enable | 2 | true | TRUE | FALSE | FALSE | FALSE | FALSE | remote archival enable setting | null
311 | log_archive_start | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | start archival process on SGA initialization | null
315 | log_archive_dest | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | archival destination text string | null
316 | log_archive_duplex_dest | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | duplex archival destination text string | null
317 | log_archive_dest_1 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #1 text string | null
318 | log_archive_dest_2 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #2 text string | null
319 | log_archive_dest_3 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #3 text string | null
320 | log_archive_dest_4 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #4 text string | null
321 | log_archive_dest_5 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #5 text string | null
322 | log_archive_dest_6 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #6 text string | null
323 | log_archive_dest_7 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #7 text string | null
324 | log_archive_dest_8 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #8 text string | null
325 | log_archive_dest_9 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #9 text string | null
326 | log_archive_dest_10 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #10 text string | null
327 | log_archive_dest_state_1 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #1 state text string | null
328 | log_archive_dest_state_2 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #2 state text string | null
329 | log_archive_dest_state_3 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #3 state text string | null
330 | log_archive_dest_state_4 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #4 state text string | null
331 | log_archive_dest_state_5 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #5 state text string | null
332 | log_archive_dest_state_6 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #6 state text string | null
333 | log_archive_dest_state_7 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #7 state text string | null
334 | log_archive_dest_state_8 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #8 state text string | null
335 | log_archive_dest_state_9 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #9 state text string | null
336 | log_archive_dest_state_10 | 2 | enable | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | archival destination #10 state text string | null
337 | log_archive_max_processes | 3 | 2 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | maximum number of active ARCH processes | null
340 | log_archive_min_succeed_dest | 3 | 1 | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | minimum number of archive destinations that must succeed | null
341 | standby_archive_dest | 2 | %ORACLE_HOME%\RDBMS | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | standby database archivelog destination text string | null
342 | log_archive_trace | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Establish archivelog operation tracing level | null
343 | fal_server | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | FAL server list | null
344 | fal_client | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | FAL client | null
345 | log_archive_format | 2 | ARC%S.%T | TRUE | FALSE | FALSE | FALSE | FALSE | archival destination format | null
353 | log_buffer | 3 | 3000320 | FALSE | FALSE | FALSE | FALSE | FALSE | redo circular buffer size | null
355 | log_checkpoint_interval | 3 | 10240 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | # redo blocks checkpoint threshold | null
356 | log_checkpoint_timeout | 3 | 1800 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | Maximum time interval between checkpoints in seconds | null
358 | archive_lag_target | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Maximum number of seconds of redos the standby could lose | null
363 | log_parallelism | 3 | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | Number of log buffer strands | null
365 | db_files | 3 | 96 | FALSE | FALSE | FALSE | FALSE | FALSE | max allowable # db files | null
366 | db_file_multiblock_read_count | 3 | 4 | FALSE | TRUE | IMMEDIATE | FALSE | FALSE | db block to be read each IO | null
368 | read_only_open_delayed | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | if TRUE delay opening of read only files until first access | null
369 | cluster_database | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | if TRUE startup in cluster database mode | null
370 | parallel_server | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | if TRUE startup in parallel server mode | null
371 | parallel_server_instances | 3 | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | number of instances to use for sizing OPS SGA structures | null
372 | cluster_database_instances | 3 | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | number of instances to use for sizing cluster db SGA structures | null
374 | db_create_file_dest | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | default database location | null
375 | db_create_online_log_dest_1 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | online log/controlfile destination #1 | null
376 | db_create_online_log_dest_2 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | online log/controlfile destination #2 | null
377 | db_create_online_log_dest_3 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | online log/controlfile destination #3 | null
378 | db_create_online_log_dest_4 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | online log/controlfile destination #4 | null
379 | db_create_online_log_dest_5 | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | online log/controlfile destination #5 | null
380 | standby_file_management | 2 | MANUAL | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | if auto then files are created/dropped automatically on standby | null
389 | gc_files_to_locks | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | mapping between file numbers and global cache locks (DFS) | null
411 | thread | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | Redo thread to mount | null
414 | fast_start_io_target | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | Upper bound on recovery reads | null
415 | fast_start_mttr_target | 3 | 300 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | MTTR target of forward crash recovery in seconds | null
420 | log_checkpoints_to_alert | 1 | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | log checkpoint begin/end to alert file | null
421 | recovery_parallelism | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | number of server processes to use for parallel recovery | null
422 | control_file_record_keep_time | 3 | 7 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | control file record keep time in days | null
423 | logmnr_max_persistent_sessions | 3 | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | maximum number of threads to mine | null
427 | dml_locks | 3 | 988 | TRUE | FALSE | FALSE | FALSE | FALSE | dml locks - one for each table modified in a transaction | null
428 | row_locking | 2 | always | TRUE | FALSE | FALSE | FALSE | FALSE | row-locking | null
429 | serializable | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | serializable | null
430 | replication_dependency_tracking | 1 | TRUE | TRUE | FALSE | FALSE | FALSE | FALSE | tracking dependency for Replication parallel propagation | null
433 | instance_number | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | instance number | null
440 | transactions | 3 | 247 | TRUE | FALSE | FALSE | FALSE | FALSE | max. number of concurrent active transactions | null
441 | transactions_per_rollback_segment | 3 | 5 | TRUE | FALSE | FALSE | FALSE | FALSE | number of active transactions per rollback segment | null
442 | max_rollback_segments | 3 | 49 | TRUE | FALSE | FALSE | FALSE | FALSE | max. number of rollback segments in SGA cache | null
444 | rollback_segments | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | undo segment list | null
449 | transaction_auditing | 1 | FALSE | FALSE | FALSE | DEFERRED | FALSE | FALSE | transaction auditing records generated in the redo log | null
452 | undo_management | 2 | AUTO | FALSE | FALSE | FALSE | FALSE | FALSE | instance runs in SMU mode if TRUE, else in RBU mode | null
453 | undo_tablespace | 2 | UNDOTBS | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | use/switch undo tablespace | null
457 | undo_suppress_errors | 1 | FALSE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | Suppress RBU errors in SMU mode | null
462 | undo_retention | 3 | 10800 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | undo retention in seconds | null
466 | fast_start_parallel_rollback | 2 | LOW | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | max number of parallel recovery slaves that may be used | null
468 | db_block_checking | 1 | FALSE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | data and index block checking | null
484 | os_roles | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | retrieve roles from the operating system | null
485 | rdbms_server_dn | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | RDBMS's Distinguished Name | null
486 | max_enabled_roles | 3 | 30 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of roles a user can have enabled | null
487 | remote_os_authent | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | allow non-secure remote clients to use auto-logon accounts | null
488 | remote_os_roles | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | allow non-secure remote clients to use os roles | null
489 | O7_DICTIONARY_ACCESSIBILITY | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Version 7 Dictionary Accessibility Support | null
491 | remote_login_passwordfile | 2 | EXCLUSIVE | FALSE | FALSE | FALSE | FALSE | FALSE | password file usage parameter | null
492 | dblink_encrypt_login | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | enforce password for distributed login always be encrypted | null
493 | license_max_users | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | maximum number of named users that can be created in the databas | null
495 | global_context_pool_size | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | Global Application Context Pool Size in Bytes | null
497 | audit_sys_operations | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | enable sys auditing | null
498 | db_domain | 2 | null | FALSE | FALSE | FALSE | FALSE | FALSE | directory part of global database name stored with CREATE DATABA | null
499 | global_names | 1 | FALSE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | enforce that database links have same name as remote database | null
500 | distributed_lock_timeout | 3 | 60 | TRUE | FALSE | FALSE | FALSE | FALSE | number of seconds a distributed transaction waits for a lock | null
502 | commit_point_strength | 3 | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | Bias this node has toward not preparing in a two-phase commit | null
503 | instance_name | 2 | wind | FALSE | FALSE | FALSE | FALSE | FALSE | instance name supported by the instance | null
504 | service_names | 2 | wind | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | service names supported by the instance | null
505 | dispatchers | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | specifications of dispatchers | null
506 | mts_dispatchers | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | specifications of dispatchers | null
507 | shared_servers | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | number of shared servers to start up | null
508 | mts_servers | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | number of shared servers to start up | null
509 | max_shared_servers | 3 | 20 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of shared servers | null
510 | mts_max_servers | 3 | 20 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of shared servers | null
511 | max_dispatchers | 3 | 5 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of dispatchers | null
512 | mts_max_dispatchers | 3 | 5 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of dispatchers | null
513 | circuits | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of circuits | null
514 | mts_circuits | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of circuits | null
515 | shared_server_sessions | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of shared server sessions | null
516 | mts_sessions | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | max number of shared server sessions | null
517 | local_listener | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | local listener | null
518 | remote_listener | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | remote listener | null
522 | mts_service | 2 | wind | TRUE | FALSE | FALSE | FALSE | FALSE | service supported by dispatchers | null
523 | mts_listener_address | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | address(es) of network listener | null
524 | mts_multiple_listeners | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Are multiple listeners enabled? | null
525 | serial_reuse | 2 | DISABLE | TRUE | FALSE | FALSE | FALSE | FALSE | reuse the frame segments | null
526 | cursor_space_for_time | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | use more memory in order to get faster execution | null
527 | session_cached_cursors | 3 | 10 | FALSE | TRUE | FALSE | FALSE | FALSE | number of cursors to save in the session cursor cache | null
528 | remote_dependencies_mode | 2 | TIMESTAMP | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | remote-procedure-call dependencies mode parameter | null
529 | utl_file_dir | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | utl_file accessible directories list | null
531 | plsql_v2_compatibility | 1 | FALSE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | PL/SQL version 2.x compatibility flag | null
532 | plsql_compiler_flags | 2 | INTERPRETED | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | PL/SQL compiler flags | null
533 | plsql_native_c_compiler | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | plsql native C compiler | null
534 | plsql_native_linker | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | plsql native linker | null
535 | plsql_native_library_dir | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | plsql native library dir | null
536 | plsql_native_make_utility | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | plsql native compilation make utility | null
537 | plsql_native_make_file_name | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | plsql native compilation make file | null
538 | plsql_native_library_subdir_count | 3 | 0 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | plsql native library number of subdirectories | null
539 | job_queue_processes | 3 | 10 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | number of job queue slave processes | null
543 | parallel_min_percent | 3 | 0 | TRUE | TRUE | FALSE | FALSE | FALSE | minimum percent of threads required for parallel query | null
546 | create_bitmap_area_size | 3 | 8388608 | TRUE | FALSE | FALSE | FALSE | FALSE | size of create bitmap buffer for bitmap index | null
547 | bitmap_merge_area_size | 3 | 1048576 | TRUE | FALSE | FALSE | FALSE | FALSE | maximum memory allow for BITMAP MERGE | null
549 | cursor_sharing | 2 | EXACT | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | cursor sharing mode | null
552 | parallel_min_servers | 3 | 0 | TRUE | FALSE | FALSE | FALSE | FALSE | minimum parallel query servers per instance | null
553 | parallel_max_servers | 3 | 5 | TRUE | FALSE | FALSE | FALSE | FALSE | maximum parallel query servers per instance | null
557 | parallel_instance_group | 2 | null | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | instance group to use for all parallel operations | null
560 | parallel_execution_message_size | 3 | 2148 | TRUE | FALSE | FALSE | FALSE | FALSE | message buffer size for parallel execution | null
568 | hash_join_enabled | 1 | TRUE | FALSE | TRUE | FALSE | FALSE | FALSE | enable/disable hash join | null
569 | hash_area_size | 3 | 10000000 | TRUE | TRUE | FALSE | FALSE | FALSE | size of in-memory hash work area | null
577 | shadow_core_dump | 2 | partial | TRUE | FALSE | FALSE | FALSE | FALSE | Core Size for Shadow Processes | null
578 | background_core_dump | 2 | partial | TRUE | FALSE | FALSE | FALSE | FALSE | Core Size for Background Processes | null
579 | background_dump_dest | 2 | D:\oracle\admin\wind\bdump | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | Detached process dump directory | null
580 | user_dump_dest | 2 | D:\oracle\admin\wind\udump | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | User process dump directory | null
581 | max_dump_file_size | 2 | 10240 | FALSE | TRUE | IMMEDIATE | FALSE | FALSE | Maximum size (blocks) of dump file | null
582 | core_dump_dest | 2 | D:\oracle\admin\wind\cdump | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | Core dump directory | null
584 | oracle_trace_enable | 1 | FALSE | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | Oracle Trace enabled/disabled | null
585 | oracle_trace_facility_path | 2 | %ORACLE_HOME%\OTRACE\ADMIN\FDF\ | TRUE | FALSE | FALSE | FALSE | FALSE | Oracle TRACE facility path | null
586 | oracle_trace_collection_path | 2 | %ORACLE_HOME%\OTRACE\ADMIN\CDF\ | TRUE | FALSE | FALSE | FALSE | FALSE | Oracle TRACE collection path | null
587 | oracle_trace_facility_name | 2 | oracled | TRUE | FALSE | FALSE | FALSE | FALSE | Oracle TRACE default facility name | null
588 | oracle_trace_collection_name | 2 | null | TRUE | FALSE | FALSE | FALSE | FALSE | Oracle TRACE default collection name | null
589 | oracle_trace_collection_size | 3 | 5242880 | TRUE | FALSE | FALSE | FALSE | FALSE | Oracle TRACE collection file max. size | null
592 | object_cache_optimal_size | 3 | 102400 | TRUE | TRUE | DEFERRED | FALSE | FALSE | optimal size of the user session's object cache in bytes | null
593 | object_cache_max_size_percent | 3 | 10 | TRUE | TRUE | DEFERRED | FALSE | FALSE | percentage of maximum size over optimal of the user session's ob | null
595 | session_max_open_files | 3 | 10 | TRUE | FALSE | FALSE | FALSE | FALSE | maximum number of open files allowed per session | null
599 | open_links | 3 | 4 | TRUE | FALSE | FALSE | FALSE | FALSE | max # open links per session | null
600 | open_links_per_instance | 3 | 4 | TRUE | FALSE | FALSE | FALSE | FALSE | max # open links per instance | null
605 | optimizer_features_enable | 2 | 9.2.0 | TRUE | FALSE | FALSE | FALSE | FALSE | optimizer plan compatibility parameter | null
606 | fixed_date | 2 | null | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | fixed SYSDATE value | null
607 | audit_trail | 2 | NONE | TRUE | FALSE | FALSE | FALSE | FALSE | enable system auditing | null
608 | sort_area_size | 3 | 5000000 | FALSE | TRUE | DEFERRED | FALSE | FALSE | size of in-memory sort work area | null
609 | sort_area_retained_size | 3 | 0 | TRUE | TRUE | DEFERRED | FALSE | FALSE | size of in-memory sort work area retained between fetch calls | null
615 | db_name | 2 | wind | FALSE | FALSE | FALSE | FALSE | FALSE | database name specified in CREATE DATABASE | null
616 | open_cursors | 3 | 750 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | max # cursors per session | null
617 | ifile | 4 | null | TRUE | FALSE | FALSE | FALSE | FALSE | include file in init.ora | null
618 | sql_trace | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | enable SQL trace | null
620 | os_authent_prefix | 2 | OPS$ | TRUE | FALSE | FALSE | FALSE | FALSE | prefix for auto-logon accounts | null
622 | optimizer_mode | 2 | CHOOSE | FALSE | TRUE | FALSE | FALSE | FALSE | optimizer mode | null
627 | sql92_security | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | require select privilege for searched update/delete | null
629 | blank_trimming | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | blank trimming semantics parameter | null
631 | partition_view_enabled | 1 | FALSE | TRUE | TRUE | FALSE | FALSE | FALSE | enable/disable partitioned views | null
634 | star_transformation_enabled | 2 | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | enable the use of star transformation | null
662 | parallel_adaptive_multi_user | 1 | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | enable adaptive setting of degree for multiple user streams | null
663 | parallel_threads_per_cpu | 3 | 2 | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | number of parallel execution threads per CPU | null
664 | parallel_automatic_tuning | 1 | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | enable intelligent defaults for parallel execution parameters | null
684 | optimizer_max_permutations | 3 | 2000 | TRUE | TRUE | FALSE | FALSE | FALSE | optimizer maximum join permutations per query block | null
685 | optimizer_index_cost_adj | 3 | 10 | FALSE | TRUE | FALSE | FALSE | FALSE | optimizer index cost adjustment | null
686 | optimizer_index_caching | 3 | 90 | FALSE | TRUE | FALSE | FALSE | FALSE | optimizer percent index caching | null
693 | query_rewrite_enabled | 2 | true | FALSE | TRUE | IMMEDIATE | FALSE | FALSE | allow rewrite of queries using materialized views if enabled | null
694 | query_rewrite_integrity | 2 | trusted | FALSE | TRUE | IMMEDIATE | FALSE | FALSE | perform rewrite using materialized views with desired integrity | null
722 | sql_version | 2 | NATIVE | TRUE | TRUE | FALSE | FALSE | FALSE | sql language version parameter for compatibility issues | null
749 | pga_aggregate_target | 6 | 75000000 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | Target size for the aggregate PGA memory consumed by the instanc | null
751 | workarea_size_policy | 2 | AUTO | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | policy used to size SQL working areas (MANUAL/AUTO) | null
770 | optimizer_dynamic_sampling | 3 | 1 | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | optimizer dynamic sampling | null
787 | statistics_level | 2 | TYPICAL | TRUE | TRUE | IMMEDIATE | FALSE | FALSE | statistics level | null
790 | aq_tm_processes | 3 | 1 | FALSE | FALSE | IMMEDIATE | FALSE | FALSE | number of AQ Time Managers to start | null
792 | hs_autoregister | 1 | TRUE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | enable automatic server DD updates in HS agent self-registration | null
793 | dg_broker_start | 1 | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | start Data Guard broker framework (DMON process) | null
794 | drs_start | 1 | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | start DG Broker monitor (DMON process) | null
795 | dg_broker_config_file1 | 2 | %ORACLE_HOME%\DATABASE\DR1%ORACLE_SID%.DAT | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | data guard broker configuration file #1 | null
796 | dg_broker_config_file2 | 2 | %ORACLE_HOME%\DATABASE\DR2%ORACLE_SID%.DAT | TRUE | FALSE | IMMEDIATE | FALSE | FALSE | data guard broker configuration file #2 | null
797 | olap_page_pool_size | 3 | 33554432 | TRUE | TRUE | DEFERRED | FALSE | FALSE | size of the olap page pool in bytes | null