http://www.redcientifica.com/oracle/

Parámetro	Descripción
spin_count	Amount to spin waiting for a latch
processes	user processes
sessions	user and system sessions
timed_statistics	maintain internal timing statistics
timed_os_statistics	internal os statistic gathering interval in seconds
resource_limit	master switch for resource limit
license_max_sessions	maximum number of non-system user sessions allowed
license_sessions_warning	warning level for number of non-system user session
lm_procs	number of client processes configured for the lock manager
lm_ress	number of resources configured for the lock manager
lm_locks	number of locks configured for the lock manager
ogms_home	GMS home directory
parallel_transaction_resource_timeout	global parallel transaction resource d
cpu_count	number of cpu's for this instance
instance_groups	list of instance group names
event	debug event control - default null string
shared_pool_size	size in bytes of shared pool
shared_pool_reserved_size	size in bytes of reserved area of shared pool
shared_pool_reserved_min_alloc	minimum allocation size in bytes for reserved
large_pool_size	size in bytes of the large allocation pool
large_pool_min_alloc	minimum allocation size in bytes for the large allocati
pre_page_sga	pre-page sga for process
shared_memory_address	SGA starting address (low order 32-bits on 64-bit plat
hi_shared_memory_address	SGA starting address (high order 32-bits on 64-bit
use_indirect_data_buffers	Enable indirect data buffers (very large SGA on 32
use_ism	Enable Shared Page Tables - ISM
lock_sga	Lock SGA in physical memory
lock_sga_areas	Lock specified areas of the SGA in physical memory
lock_name_space	lock name space used for generating lock names for standby/c
enqueue_resources	resources for enqueues
nls_language	NLS language name
nls_territory	NLS territory name
nls_sort	NLS linguistic definition name
nls_date_language	NLS date language name
nls_date_format	NLS Oracle date format
nls_currency	NLS local currency symbol
nls_numeric_characters	NLS numeric characters
nls_iso_currency	NLS ISO currency territory name
nls_calendar	NLS calendar system name
disk_asynch_io	Use asynch I/O for random access devices
tape_asynch_io	Use asynch I/O requests for tape devices
dbwr_io_slaves	DBWR I/O slaves
lgwr_io_slaves	LGWR I/O slaves
arch_io_slaves	ARCH I/O slaves
backup_disk_io_slaves	BACKUP Disk I/O slaves
backup_tape_io_slaves	BACKUP Tape I/O slaves
db_file_direct_io_count	Sequential I/O block count
control_files	control file names list
db_file_name_convert	datafile name convert pattern and string for standby/cl
log_file_name_convert	logfile name convert pattern and string for standby/cl
db_block_buffers	Number of database blocks cached in memory
buffer_pool_keep	Number of database blocks/latches in keep buffer pool
buffer_pool_recycle	Number of database blocks/latches in recycle buffer pool
db_block_checksum	store checksum in db blocks and check during reads
db_block_size	Size of database block in bytes
db_block_checkpoint_batch	Max number of blocks to checkpoint in a DB Writer
db_block_lru_statistics	Maintain buffer cache LRU hits-by-position statistic
db_block_lru_extended_statistics	Maintain buffer cache LRU statistics for la
db_writer_processes	number of background database writer processes to start
db_block_lru_latches	number of lru latches
db_block_max_dirty_target	Target upper bound on number of buffers that can b
max_commit_propagation_delay	Max age of new snapshot in .01 seconds
compatible	Database will be completely compatible with this software versio
compatible_no_recovery	Database will be compatible unless crash or media rec
log_archive_start	start archival process on SGA initialization
log_archive_buffers	Number of buffers to allocate for archiving
log_archive_buffer_size	Size of each archival buffer in log file blocks
log_archive_dest	archival destination text string
log_archive_duplex_dest	duplex archival destination text string
log_archive_min_succeed_dest	minimum number of archive destinations that mus
log_archive_format	archival destination format
log_buffer	redo circular buffer size
log_checkpoint_interval	# redo blocks checkpoint threshold
log_checkpoint_timeout	Maximum time interval between checkpoints in seconds
log_block_checksum	calculate checksum for redo blocks when writing
log_small_entry_max_size	redo entries larger than this will acquire the redo
log_simultaneous_copies	number of simultaneous copies into redo buffer(# of
db_files	max allowable # db files
db_file_simultaneous_writes	max simultaneous (overlaped) writes per db file
db_file_multiblock_read_count	db block to be read each IO
log_files	max allowable # log files
read_only_open_delayed	if TRUE delay opening of read only files until first
parallel_server	if TRUE startup in parallel server mode
gc_lck_procs	number of background parallel server lock processes to start
gc_latches	number of latches per lock process
gc_releasable_locks	number of releasable locks (DFS)
gc_rollback_locks	locks for the rollback segments (DFS)
gc_files_to_locks	mapping between file numbers and lock buckets (DFS)
gc_defer_time	how long to defer forced writes for hot buffers (DFS)
thread	Redo thread to mount
freeze_DB_for_fast_instance_recovery	freeze database during instance recover
log_checkpoints_to_alert	log checkpoint begin/end to alert file
recovery_parallelism	number of server processes to use for parallel recovery
control_file_record_keep_time	control file record keep time in days
temporary_table_locks	temporary table locks
dml_locks	dml locks - one for each table modified in a transaction
row_locking	row-locking
serializable	serializable
replication_dependency_tracking	tracking dependency for Replication parallel
delayed_logging_block_cleanouts	turn on delayed-logging block cleanouts feat
instance_number	instance number
max_rollback_segments	max. number of rollback segments in SGA cache
transactions	max. number of concurrent active transactions
transactions_per_rollback_segment	number of active transactions per rollback
rollback_segments	undo segment list
cleanup_rollback_entries	no. of undo entries to apply per transaction cleanu
transaction_auditing	transaction auditing records generated in the redo log
discrete_transactions_enabled	enable OLTP mode
sequence_cache_entries	number of sequence cache entries
sequence_cache_hash_buckets	number of sequence cache hash buckets
row_cache_cursors	number of cached cursors for row cache management
os_roles	retrieve roles from the operating system
max_enabled_roles	max number of roles a user can have enabled
remote_os_authent	allow non-secure remote clients to use auto-logon accounts
remote_os_roles	allow non-secure remote clients to use os roles
O7_DICTIONARY_ACCESSIBILITY	Version 7 Dictionary Accessibility Support
remote_login_passwordfile	password file usage parameter
dblink_encrypt_login	enforce password for distributed login always be encryp
license_max_users	maximum number of named users that can be created in the d
db_domain	directory part of global database name stored with CREATE DATABA
global_names	enforce that database links have same name as remote database
distributed_lock_timeout	number of seconds a distributed transaction waits f
distributed_transactions	max. number of concurrent distributed transactions
max_transaction_branches	max. number of branches per distributed transaction
distributed_recovery_connection_hold_time	number of seconds RECO holds outbo
commit_point_strength	Bias this node has toward not preparing in a two-phase
mts_service	service supported by dispatchers
mts_rate_log_size	number of rate statistic events to log
mts_rate_scale	scale to display rate statistic (100ths of a second)
mts_dispatchers	specifications of dispatchers
mts_servers	number of servers to start up
mts_max_servers	max number of servers
mts_max_dispatchers	max number of dispatchers
local_listener	local listener
mts_listener_address	address(es) of network listener
mts_multiple_listeners	Are multiple listeners enabled?
open_links	max # open links per session
open_links_per_instance	max # open links per instance
close_cached_open_cursors	close cursors cached by PL/SQL at each commit
optimizer_features_enable	optimizer plan compatibility parameter
fixed_date	fixed SYSDATE value
audit_trail	enable system auditing
sort_area_size	size of in-memory sort work area
sort_area_retained_size	size of in-memory sort work area retained between fe
sort_direct_writes	use direct write
sort_write_buffers	number of sort direct write buffers
sort_write_buffer_size	size of each sort direct write buffer
sort_spacemap_size	size of sort disk area space map
sort_read_fac	multi-block read factor for sort
db_name	database name specified in CREATE DATABASE
open_cursors	max # cursors per process
ifile	include file in init.ora
sql_trace	enable SQL trace
os_authent_prefix	prefix for auto-logon accounts
optimizer_mode	optimizer mode
sql92_security	require select privilege for searched update/delete
blank_trimming	blank trimming semantics parameter
always_anti_join	always use this anti-join when possible
partition_view_enabled	enable/disable partitioned views
b_tree_bitmap_plans	enable the use of bitmap plans for tables w. only B-tree
star_transformation_enabled	enable the use of star transformation
complex_view_merging	enable complex view merging
push_join_predicate	enable pushing join predicate inside a view
fast_full_scan_enabled	enable fast full scan
parallel_broadcast_enabled	enable broadcasting of small inputs to hash and s
parallel_adaptive_multi_user	enable adaptive setting of degree for multiple
always_semi_join	always use this semi-join when possible
serial_reuse	reuse the frame segments
cursor_space_for_time	use more memory in order to get faster execution
session_cached_cursors	number of cursors to save in the session cursor cache
text_enable	enable text searching
remote_dependencies_mode	remote-procedure-call dependencies mode parameter
utl_file_dir	utl_file accessible directories list
plsql_v2_compatibility	PL/SQL version 2.x compatibility flag
job_queue_processes	number of job queue processes to start
job_queue_interval	Wakeup interval in seconds for job queue processes
job_queue_keep_connections	Keep network connections between execution of job
snapshot_refresh_processes	number of job queue processes to start
snapshot_refresh_interval	Wakeup interval in seconds for job queue processes
snapshot_refresh_keep_connections	Keep network connections between execution
optimizer_percent_parallel	optimizer percent parallel
optimizer_search_limit	optimizer search limit
parallel_min_percent	minimum percent of threads required for parallel query
parallel_default_max_instances	default maximum number of instances for paral
cache_size_threshold	maximum size of table or piece to be cached (in blocks)
create_bitmap_area_size	size of create bitmap buffer for bitmap index
bitmap_merge_area_size	maximum memory allow for BITMAP MERGE
parallel_min_servers	minimum parallel query servers per instance
parallel_max_servers	maximum parallel query servers per instance
parallel_server_idle_time	idle time before parallel query server dies
allow_partial_sn_results	allow partial results when processing gv$ views
parallel_instance_group	instance group to use for all parallel operations
ops_admin_group	instance group to use for global v$ queries
parallel_execution_message_size	message buffer size for parallel execution
parallel_min_message_pool	minimum size of shared pool memory to reserve for
hash_join_enabled	enable/disable hash join
hash_area_size	size of in-memory hash work area
hash_multiblock_io_count	number of blocks hash join will read/write at once
shadow_core_dump	Core Size for Shadow Processes
background_core_dump	Core Size for Background Processes
background_dump_dest	Detached process dump directory
user_dump_dest	User process dump directory
max_dump_file_size	Maximum size (blocks) of dump file
core_dump_dest	Core dump directory
audit_file_dest	Directory in which auditing files are to reside
reduce_alarm	Reduce Alarm
oracle_trace_enable	Oracle TRACE instance wide enable/disable
oracle_trace_facility_path	Oracle TRACE facility path
oracle_trace_collection_path	Oracle TRACE collection path
oracle_trace_facility_name	Oracle TRACE default facility name
oracle_trace_collection_name	Oracle TRACE default collection name
oracle_trace_collection_size	Oracle TRACE collection file max. size
object_cache_optimal_size	optimal size of the user session's object cache in
object_cache_max_size_percent	percentage of maximum size over optimal of the
session_max_open_files	maximum number of open files allowed per session
aq_tm_processes	number of AQ Time Managers to start

Buzón de contacto © 1999-2004 Manuel de la Herrán Gascón

7/7