| 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 |