Share |
Legend:
  • : Not a valid parameter
  • : Parameter is available in this version
  • : Parameter is available but should not be used anymore

Parameter name Description 7.3 8.0 8.1 9.0 9.2 10.1 10.2 11.1 11.2
O7_DICTIONARY_ACCESSIBILITYVersion 7 Dictionary Accessibility Support
__db_cache_sizeActual size of DEFAULT buffer pool for standard block size buffers
__java_pool_sizeActual size in bytes of java pool
__large_pool_sizeActual size in bytes of large pool
__shared_pool_sizeActual size in bytes of shared pool
active_instance_countnumber of active instances in the cluster database
allow_partial_sn_resultsallow partial results when processing gv$ views
always_anti_joinalways use this anti-join when possible
always_semi_joinalways use this method for semi-join when possible
aq_tm_processesnumber of AQ Time Managers to start
arch_io_slavesARCH I/O slaves
archive_lag_targetMaximum number of seconds of redos the standby could lose
asm_diskgroupsdisk groups to mount automatically
asm_diskstringdisk set locations for discovery
asm_power_limitnumber of processes for disk rebalancing
asm_preferred_read_failure_groupspreferred read failure groups
audit_file_destDirectory in which auditing files are to reside
audit_sys_operationsenable sys auditing
audit_syslog_levelSyslog facility and level
audit_trailenable system auditing
b_tree_bitmap_plansenable the use of bitmap plans for tables w. only B-tree indexes
background_core_dumpCore Size for Background Processes
background_dump_destDetached process dump directory
backup_disk_io_slavesBACKUP Disk I/O slaves
backup_tape_io_slavesBACKUP Tape I/O slaves
bitmap_merge_area_sizemaximum memory allow for BITMAP MERGE
blank_trimmingblank trimming semantics parameter
buffer_pool_keepNumber of database blocks/latches in keep buffer pool
buffer_pool_recycleNumber of database blocks/latches in recycle buffer pool
cache_size_thresholdmaximum size of table or piece to be cached (in blocks)
cell_offload_compactionCell packet compaction strategy
cell_offload_decryptionenable SQL processing offload of encrypted data to cells
cell_offload_parametersAdditional cell offload parameters
cell_offload_plan_displayCell offload explain plan display
cell_offload_processingenable SQL processing offload to cells
cell_partition_large_extentsEnables large extent allocation for partitioned tables
checkpoint_processcreate a separate checkpoint process
circuitsmax number of circuits
cleanup_rollback_entriesno. of undo entries to apply per transaction cleanup
client_result_cache_lagclient result cache maximum lag in milliseconds
client_result_cache_sizeclient result cache max size in bytes
close_cached_open_cursorsclose cursors cached by PL/SQL at each commit
cluster_databaseif TRUE startup in cluster database mode
cluster_database_instancesnumber of instances to use for sizing cluster db SGA structures
cluster_interconnectsinterconnects for RAC use
commit_loggingtransaction commit log write behaviour
commit_point_strengthBias this node has toward not preparing in a two-phase commit
commit_waittransaction commit log wait behaviour
commit_writetransaction commit log write behaviour
compatibleDatabase will be completely compatible with this software version
compatible_no_recoveryDatabase will be compatible unless crash or media recovery is ne
complex_view_mergingenable complex view merging
control_file_record_keep_timecontrol file record keep time in days
control_filescontrol file names list
control_management_pack_accessdeclares which manageability packs are enabled
core_dump_destCore dump directory
cpu_countnumber of CPUs for this instance
create_bitmap_area_sizesize of create bitmap buffer for bitmap index
create_stored_outlinescreate stored outlines for DML statements
cursor_sharingcursor sharing mode
cursor_space_for_timeuse more memory in order to get faster execution
db_16k_cache_sizeSize of cache for 16K buffers
db_2k_cache_sizeSize of cache for 2K buffers
db_32k_cache_sizeSize of cache for 32K buffers
db_4k_cache_sizeSize of cache for 4K buffers
db_8k_cache_sizeSize of cache for 8K buffers
db_block_buffersNumber of database blocks cached in memory
db_block_checkingheader checking and data and index block checking
db_block_checkpoint_batchMax number of blocks to checkpoint in a DB Writer IO
db_block_checksumstore checksum in db blocks and check during reads
db_block_lru_extended_statisticsMaintain buffer cache LRU statistics for last N blocks discarded
db_block_lru_latchesnumber of lru latches
db_block_lru_statisticsMaintain buffer cache LRU hits-by-position statistics (slow)
db_block_max_dirty_targetUpper bound on modified buffers/recovery reads
db_block_sizeSize of database block in bytes
db_cache_adviceBuffer cache sizing advisory
db_cache_sizeSize of DEFAULT buffer pool for standard block size buffers
db_create_file_destdefault database location
db_create_online_log_dest_1online log/controlfile destination #1
db_create_online_log_dest_2online log/controlfile destination #2
db_create_online_log_dest_3online log/controlfile destination #3
db_create_online_log_dest_4online log/controlfile destination #4
db_create_online_log_dest_5online log/controlfile destination #5
db_domaindirectory part of global database name stored with CREATE DATABASE
db_file_direct_io_countSequential I/O block count
db_file_multiblock_read_countdb block to be read each IO
db_file_name_convertdatafile name convert patterns and strings for standby/clone db
db_file_simultaneous_writesmax simultaneous (overlaped) writes per db file
db_file_standby_name_convertdatafile name convert pattern and string for standby database
db_filesmax allowable # db files
db_flash_cache_fileflash cache file for default block size
db_flash_cache_sizeflash cache size for db_flash_cache_file
db_flashback_retention_targetMaximum Flashback Database log retention time in minutes.
db_keep_cache_sizeSize of KEEP buffer pool for standard block size buffers
db_lost_write_protectenable lost write detection
db_namedatabase name specified in CREATE DATABASE
db_recovery_file_destdefault database recovery file location
db_recovery_file_dest_sizedatabase recovery files size limit
db_recycle_cache_sizeSize of RECYCLE buffer pool for standard block size buffers
db_securefilepermit securefile storage during lob creation
db_ultra_safeSets defaults for other parameters that control protection levels
db_unique_nameDatabase Unique Name
db_writer_processesnumber of background database writer processes to start
dblink_encrypt_loginenforce password for distributed login always be encrypted
dbwr_io_slavesDBWR I/O slaves
ddl_lock_timeouttimeout to restrict the time that ddls wait for dml lock
ddl_wait_for_locksDisable NOWAIT DML lock acquisitions
deferred_segment_creationdefer segment creation to first insert
delayed_logging_block_cleanoutsturn on delayed-logging block cleanouts feature
dg_broker_config_file1data guard broker configuration file #1
dg_broker_config_file2data guard broker configuration file #2
dg_broker_startstart Data Guard broker framework (DMON process)
diagnostic_destdiagnostic base directory
discrete_transactions_enabledenable OLTP mode
disk_asynch_ioUse asynch I/O for random access devices
dispatchersspecifications of dispatchers
distributed_lock_timeoutnumber of seconds a distributed transaction waits for a lock
distributed_recovery_connection_hold_timenumber of seconds RECO holds outbound connections open
distributed_transactionsmax. number of concurrent distributed transactions
dml_locksdml locks - one for each table modified in a transaction
drs_startstart DG Broker monitor (DMON process)
dst_upgrade_insert_convEnables/Disables internal conversions during DST upgrade
enable_ddl_loggingenable ddl logging
enqueue_resourcesresources for enqueues
eventdebug event control - default null string
fal_clientFAL client
fal_serverFAL server list
fast_cache_flushenable fast cache flush for parallel query
fast_full_scan_enabledenable fast full scan
fast_start_io_targetUpper bound on recovery reads
fast_start_mttr_targetMTTR target in seconds
fast_start_parallel_rollbackmax number of parallel recovery slaves that may be used
file_mappingenable file mapping
fileio_network_adaptersNetwork Adapters for File I/O
filesystemio_optionsIO operations on filesystem files
fixed_datefixed SYSDATE value
freeze_DB_for_fast_instance_recoveryfreeze database during instance recovery
gc_db_locks# DB locks (DFS)
gc_defer_timehow long to defer down converts for hot buffers (DFS)
gc_files_to_locksmapping between file numbers and global cache locks
gc_freelist_groups# freelist groups locks in (DFS)
gc_latchesnumber of latches per lock process
gc_lck_procsnumber of background parallel server lock processes to start
gc_releasable_locks# releasable DB locks (DFS)
gc_rollback_locks# Undo locks in (DFS)
gc_rollback_segments# Undo Segments
gc_save_rollback_locks# Save Undo locks in (DFS)
gc_segments# Segment headers
gc_tablespaces# tablespaces
gcs_server_processesnumber of background gcs server processes to start
global_context_pool_sizeGlobal Application Context Pool Size in Bytes
global_namesenforce that database links have same name as remote database
global_txn_processesnumber of background global transaction processes to start
hash_area_sizesize of in-memory hash work area
hash_join_enabledenable/disable hash join
hash_multiblock_io_countnumber of blocks hash join will read/write at once
hi_shared_memory_addressSGA starting address (high order 32-bits on 64-bit platforms)
hpux_sched_noagesecond spare parameter - integer
hs_autoregisterenable automatic server DD updates in HS agent self-registration
ifileinclude file in init.ora
instance_groupslist of instance group names
instance_nameinstance name supported by the instance
instance_numberinstance number
instance_typetype of instance to be executed
java_jit_enabledJava VM JIT enabled
java_max_sessionspace_sizemax allowed size in bytes of a Java sessionspace
java_pool_sizesize in bytes of java pool
java_soft_sessionspace_limitwarning limit on size in bytes of a Java sessionspace
job_queue_intervalWakeup interval in seconds for job queue processes
job_queue_keep_connectionsKeep network connections between execution of jobs
job_queue_processesmaximum number of job queue slave processes
large_pool_min_allocminimum allocation size in bytes for the large allocation pool
large_pool_sizesize in bytes of large pool
ldap_directory_accessRDBMS's LDAP access option
ldap_directory_sysauthOID usage parameter
lgwr_io_slavesLGWR I/O slaves
license_max_sessionsmaximum number of non-system user sessions allowed
license_max_usersmaximum number of named users that can be created in the database
license_sessions_warningwarning level for number of non-system user sessions
listener_networkslistener registration networks
lm_locksnumber of locks configured for the lock manager
lm_procsnumber of client processes configured for the lock manager
lm_ressnumber of resources configured for the lock manager
local_listenerlocal listener
lock_name_spacelock name space used for generating lock names for standby/clone database
lock_sgaLock entire SGA in physical memory
lock_sga_areasLock specified areas of the SGA in physical memory
log_archive_buffer_sizeSize of each archival buffer in log file blocks
log_archive_buffersNumber of buffers to allocate for archiving
log_archive_configlog archive config parameter
log_archive_destarchival destination text string
log_archive_dest_1archival destination #1 text string
log_archive_dest_10archival destination #10 text string
log_archive_dest_11archival destination #11 text string
log_archive_dest_12archival destination #12 text string
log_archive_dest_13archival destination #13 text string
log_archive_dest_14archival destination #14 text string
log_archive_dest_15archival destination #15 text string
log_archive_dest_16archival destination #16 text string
log_archive_dest_17archival destination #17 text string
log_archive_dest_18archival destination #18 text string
log_archive_dest_19archival destination #19 text string
log_archive_dest_2archival destination #2 text string
log_archive_dest_20archival destination #20 text string
log_archive_dest_21archival destination #21 text string
log_archive_dest_22archival destination #22 text string
log_archive_dest_23archival destination #23 text string
log_archive_dest_24archival destination #24 text string
log_archive_dest_25archival destination #25 text string
log_archive_dest_26archival destination #26 text string
log_archive_dest_27archival destination #27 text string
log_archive_dest_28archival destination #28 text string
log_archive_dest_29archival destination #29 text string
log_archive_dest_3archival destination #3 text string
log_archive_dest_30archival destination #30 text string
log_archive_dest_31archival destination #31 text string
log_archive_dest_4archival destination #4 text string
log_archive_dest_5archival destination #5 text string
log_archive_dest_6archival destination #6 text string
log_archive_dest_7archival destination #7 text string
log_archive_dest_8archival destination #8 text string
log_archive_dest_9archival destination #9 text string
log_archive_dest_state_1archival destination #1 state text string
log_archive_dest_state_10archival destination #10 state text string
log_archive_dest_state_11archival destination #11 state text string
log_archive_dest_state_12archival destination #12 state text string
log_archive_dest_state_13archival destination #13 state text string
log_archive_dest_state_14archival destination #14 state text string
log_archive_dest_state_15archival destination #15 state text string
log_archive_dest_state_16archival destination #16 state text string
log_archive_dest_state_17archival destination #17 state text string
log_archive_dest_state_18archival destination #18 state text string
log_archive_dest_state_19archival destination #19 state text string
log_archive_dest_state_2archival destination #2 state text string
log_archive_dest_state_20archival destination #20 state text string
log_archive_dest_state_21archival destination #21 state text string
log_archive_dest_state_22archival destination #22 state text string
log_archive_dest_state_23archival destination #23 state text string
log_archive_dest_state_24archival destination #24 state text string
log_archive_dest_state_25archival destination #25 state text string
log_archive_dest_state_26archival destination #26 state text string
log_archive_dest_state_27archival destination #27 state text string
log_archive_dest_state_28archival destination #28 state text string
log_archive_dest_state_29archival destination #29 state text string
log_archive_dest_state_3archival destination #3 state text string
log_archive_dest_state_30archival destination #30 state text string
log_archive_dest_state_31archival destination #31 state text string
log_archive_dest_state_4archival destination #4 state text string
log_archive_dest_state_5archival destination #5 state text string
log_archive_dest_state_6archival destination #6 state text string
log_archive_dest_state_7archival destination #7 state text string
log_archive_dest_state_8archival destination #8 state text string
log_archive_dest_state_9archival destination #9 state text string
log_archive_duplex_destduplex archival destination text string
log_archive_formatarchival destination format
log_archive_local_firstEstablish EXPEDITE attribute default value
log_archive_max_processesmaximum number of active ARCH processes
log_archive_min_succeed_destminimum number of archive destinations that must succeed
log_archive_startstart archival process on SGA initialization
log_archive_traceEstablish archivelog operation tracing level
log_block_checksumcalculate checksum for redo blocks when writing
log_bufferredo circular buffer size
log_checkpoint_interval# redo blocks checkpoint threshold
log_checkpoint_timeoutMaximum time interval between checkpoints in seconds
log_checkpoints_to_alertlog checkpoint begin/end to alert file
log_file_name_convertlogfile name convert patterns and strings for standby/clone db
log_file_standby_name_convertlogfile name convert pattern and string for standby database
log_filesmax allowable # log files
log_parallelismNumber of log buffer strands
log_simultaneous_copiesnumber of simultaneous copies into redo buffer(# of copy latches
log_small_entry_max_sizeredo entries larger than this will acquire the redo copy latch
logmnr_max_persistent_sessionsmaximum number of threads to mine
max_commit_propagation_delayMax age of new snapshot in .01 seconds
max_dispatchersmax number of dispatchers
max_dump_file_sizeMaximum size (in bytes) of dump file
max_enabled_rolesmax number of roles a user can have enabled
max_rollback_segmentsmax. number of rollback segments in SGA cache
max_shared_serversmax number of shared servers
max_transaction_branchesmax. number of branches per distributed transaction
memory_max_targetMax size for Memory Target
memory_targetTarget size of Oracle SGA and PGA memory
mts_circuitsmax number of circuits
mts_dispatchersspecifications of dispatchers
mts_listener_addressaddress(es) of network listener
mts_max_dispatchersmax number of dispatchers
mts_max_serversmax number of servers
mts_multiple_listenersAre multiple listeners enabled?
mts_rate_log_sizenumber of rate statistic events to log
mts_rate_scalescale to display rate statistic (100ths of a second)
mts_serversnumber of servers to start up
mts_serviceservice supported by dispatchers
mts_sessionsmax number of shared server sessions
nls_calendarNLS calendar system name
nls_compNLS comparison
nls_currencyNLS local currency symbol
nls_date_formatNLS Oracle date format
nls_date_languageNLS date language name
nls_dual_currencyDual currency symbol
nls_iso_currencyNLS ISO currency territory name
nls_languageNLS language name
nls_length_semanticscreate columns using byte or char semantics by default
nls_nchar_conv_excpNLS raise an exception instead of allowing implicit conversion
nls_numeric_charactersNLS numeric characters
nls_sortNLS linguistic definition name
nls_territoryNLS territory name
nls_time_formattime format
nls_time_tz_formattime with timezone format
nls_timestamp_formattime stamp format
nls_timestamp_tz_formattimestampe with timezone format
object_cache_max_size_percentpercentage of maximum size over optimal of the user session's object cache
object_cache_optimal_sizeoptimal size of the user session's object cache in bytes
ogms_homeGMS home directory
olap_page_pool_sizesize of the olap page pool in bytes
open_cursorsmax # cursors per session
open_linksmax # open links per session
open_links_per_instancemax # open links per instance
ops_admin_groupinstance group to use for global v$ queries
ops_interconnectsinterconnects for ops use
optimizer_capture_sql_plan_baselinesautomatic capture of SQL plan baselines for repeatable statements
optimizer_dynamic_samplingoptimizer dynamic sampling
optimizer_features_enableoptimizer plan compatibility parameter
optimizer_index_cachingoptimizer percent index caching
optimizer_index_cost_adjoptimizer index cost adjustment
optimizer_max_permutationsoptimizer maximum join permutations per query block
optimizer_modeoptimizer mode
optimizer_parallel_passoptimizer parallel pass
optimizer_percent_paralleloptimizer percent parallel
optimizer_search_limitoptimizer search limit
optimizer_secure_view_mergingoptimizer secure view merging and predicate pushdown/movearound
optimizer_use_invisible_indexesUsage of invisible indexes (TRUE/FALSE)
optimizer_use_pending_statisticsControl whether to use optimizer pending statistics
optimizer_use_sql_plan_baselinesuse of SQL plan baselines for captured sql statements
oracle_trace_collection_nameOracle TRACE default collection name
oracle_trace_collection_pathOracle TRACE collection path
oracle_trace_collection_sizeOracle TRACE collection file max. size
oracle_trace_enableOracle TRACE instance wide enable/disable
oracle_trace_facility_nameOracle TRACE default facility name
oracle_trace_facility_pathOracle TRACE facility path
os_authent_prefixprefix for auto-logon accounts
os_rolesretrieve roles from the operating system
parallel_adaptive_multi_userenable adaptive setting of degree for multiple user streams
parallel_automatic_tuningenable intelligent defaults for parallel execution parameters
parallel_broadcast_enabledenable broadcasting of small inputs to hash and sort merge joins
parallel_default_max_instancesdefault maximum number of instances for parallel query
parallel_degree_limitlimit placed on degree of parallelism
parallel_degree_policypolicy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
parallel_execution_message_sizemessage buffer size for parallel execution
parallel_force_localforce single instance execution
parallel_instance_groupinstance group to use for all parallel operations
parallel_io_cap_enabledenable capping DOP by IO bandwidth
parallel_max_serversmaximum parallel query servers per instance
parallel_min_message_poolminimum size of shared pool memory to reserve for pq servers
parallel_min_percentminimum percent of threads required for parallel query
parallel_min_serversminimum parallel query servers per instance
parallel_min_time_thresholdthreshold above which a plan is a candidate for parallelization (in seconds)
parallel_serverif TRUE startup in parallel server mode
parallel_server_idle_timeidle time before parallel query server dies
parallel_server_instancesnumber of instances to use for sizing OPS SGA structures
parallel_servers_targetinstance target in terms of number of parallel servers
parallel_threads_per_cpunumber of parallel execution threads per CPU
parallel_transaction_resource_timeoutglobal parallel transaction resource deadlock timeout in seconds
partition_view_enabledenable/disable partitioned views
permit_92_wrap_formatallow 9.2 or older wrap format in PL/SQL
pga_aggregate_targetTarget size for the aggregate PGA memory consumed by the instance
plscope_settingsplscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data
plsql_ccflagsPL/SQL ccflags
plsql_code_typePL/SQL code-type
plsql_compiler_flagsPL/SQL compiler flags
plsql_debugPL/SQL debug
plsql_native_c_compilerplsql native C compiler
plsql_native_library_dirplsql native library dir
plsql_native_library_subdir_countplsql native library number of subdirectories
plsql_native_linkerplsql native linker
plsql_native_make_file_nameplsql native compilation make file
plsql_native_make_utilityplsql native compilation make utility
plsql_optimize_levelPL/SQL optimize level
plsql_v2_compatibilityPL/SQL version 2.x compatibility flag
plsql_warningsPL/SQL compiler warnings settings
pre_page_sgapre-page sga for process
processesuser processes
push_join_predicateenable pushing join predicate inside a view
query_rewrite_enabledallow rewrite of queries using materialized views if enabled
query_rewrite_integrityperform rewrite using materialized views with desired integrity
rdbms_server_dnRDBMS's Distinguished Name
read_only_open_delayedif TRUE delay opening of read only files until first access
recovery_parallelismnumber of server processes to use for parallel recovery
recyclebinrecyclebin processing
redo_transport_userData Guard transport user when using password file
remote_archive_enableremote archival enable setting
remote_dependencies_moderemote-procedure-call dependencies mode parameter
remote_listenerremote listener
remote_login_passwordfilepassword file usage parameter
remote_os_authentallow non-secure remote clients to use auto-logon accounts
remote_os_rolesallow non-secure remote clients to use os roles
replication_dependency_trackingtracking dependency for Replication parallel propagation
resource_limitmaster switch for resource limit
resource_manager_cpu_allocationResource Manager CPU allocation
resource_manager_planresource mgr top plan
result_cache_max_resultmaximum result size as percent of cache size
result_cache_max_sizemaximum amount of memory to be used by the cache
result_cache_moderesult cache operator usage mode
result_cache_remote_expirationmaximum life time (min) for any result using a remote object
resumable_timeoutset resumable_timeout
rollback_segmentsundo segment list
row_cache_cursorsnumber of cached cursors for row cache management
row_lockingrow-locking
sec_case_sensitive_logoncase sensitive password enabled for logon
sec_max_failed_login_attemptsmaximum number of failed login attempts on a connection
sec_protocol_error_further_actionTTC protocol error continue action
sec_protocol_error_trace_actionTTC protocol error action
sec_return_server_release_bannerwhether the server retruns the complete version information
sequence_cache_entriesnumber of sequence cache entries
sequence_cache_hash_bucketsnumber of sequence cache hash buckets
serial_reusereuse the frame segments
serializableserializable
service_namesservice names supported by the instance
session_cached_cursorsNumber of cursors to cache in a session.
session_max_open_filesmaximum number of open files allowed per session
sessionsuser and system sessions
sga_max_sizemax total SGA size
sga_targetTarget size of SGA
shadow_core_dumpCore Size for Shadow Processes
shared_memory_addressSGA starting address (low order 32-bits on 64-bit platforms)
shared_pool_reserved_min_allocminimum allocation size in bytes for reserved area of shared poo
shared_pool_reserved_sizesize in bytes of reserved area of shared pool
shared_pool_sizesize in bytes of shared pool
shared_server_sessionsmax number of shared server sessions
shared_serversnumber of shared servers to start up
skip_unusable_indexesskip unusable indexes if set to TRUE
smtp_out_serverutl_smtp server and port configuration parameter
snapshot_refresh_intervalWakeup interval in seconds for job queue processes
snapshot_refresh_keep_connectionsKeep network connections between execution of jobs
snapshot_refresh_processesnumber of job queue processes to start
sort_area_retained_sizesize of in-memory sort work area retained between fetch calls
sort_area_sizesize of in-memory sort work area
sort_direct_writesuse direct write
sort_multiblock_read_countmulti-block read count for sort
sort_read_facmulti-block read factor for sort
sort_spacemap_sizesize of sort disk area space map
sort_write_buffer_sizesize of each sort direct write buffer
sort_write_buffersnumber of sort direct write buffers
sp_nameService Provider Name
spfileserver parameter file
spin_countAmount to spin waiting for a latch
sql92_securityrequire select privilege for searched update/delete
sql_traceenable SQL trace
sql_versionsql language version parameter for compatibility issues
sqltune_categoryCategory qualifier for applying hintsets
standby_archive_deststandby database archivelog destination text string
standby_file_managementif auto then files are created/dropped automatically on standby
standby_preserves_namesFile names on standby are the same as on the primary.
star_transformation_enabledenable the use of star transformation
statistics_levelstatistics level
streams_pool_sizesize in bytes of the streams pool
tape_asynch_ioUse asynch I/O requests for tape devices
temporary_table_lockstemporary table locks
text_enableenable text searching
threadRedo thread to mount
timed_os_statisticsinternal os statistic gathering interval in seconds
timed_statisticsmaintain internal timing statistics
trace_enabledenable in memory tracing
tracefile_identifiertrace file custom identifier
transaction_auditingtransaction auditing records generated in the redo log
transactionsmax. number of concurrent active transactions
transactions_per_rollback_segmentnumber of active transactions per rollback segment
undo_managementinstance runs in SMU mode if TRUE, else in RBU mode
undo_retentionundo retention in seconds
undo_suppress_errorsSuppress RBU errors in SMU mode
undo_tablespaceuse/switch undo tablespace
unlimited_rollback_segmentsallow unlimited extents for rollback segments
use_indirect_data_buffersEnable indirect data buffers (very large SGA on 32-bit platforms)
use_ismEnable Shared Page Tables - ISM
user_dump_destUser process dump directory
utl_file_dirutl_file accessible directories list
v733_plans_enabledenable/disable several performance features introduced in 7.3.3
workarea_size_policypolicy used to size SQL working areas (MANUAL/AUTO)
xml_db_eventsare XML DB events enabled