select * from V$PARAMETER

Connect time(ms): 63

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 15

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

