ora parms

INSTANCE	NAME	VALUE	DEFAULT	DESCRIPTION	SES_MODIFIABLE	SYS_MODIFIABLE	ISSYS_MODIFIABLE	UPDATE_COMMENT
HCMPROD	O7_DICTIONARY_ACCESSIBILITY	FALSE	YES	Version 7 Dictionary Accessibility Support	NO	NO	FALSE	NULL
HCMPROD	_gby_hash_aggregation_enabled	FALSE	NO	enable group-by and aggregation using hash scheme	YES	YES	FALSE	NULL
HCMPROD	_index_join_enabled	FALSE	NO	enable the use of index joins	YES	YES	FALSE	uncomment during conversion and afterward comment out.
HCMPROD	_object_statistics	FALSE	NO	enable the object level statistics collection	NO	YES	FALSE	NULL
HCMPROD	_unnest_subquery	FALSE	NO	enables unnesting of correlated subqueries	YES	YES	FALSE	NULL
HCMPROD	active_instance_count	NULL	YES	number of active instances in the cluster database	NO	NO	FALSE	NULL
HCMPROD	aq_tm_processes	1	NO	number of AQ Time Managers to start	NO	YES	FALSE	NULL
HCMPROD	archive_lag_target	0	YES	Maximum number of seconds of redos the standby could lose	NO	YES	FALSE	NULL
HCMPROD	asm_diskgroups	NULL	YES	disk groups to mount automatically	NO	YES	FALSE	NULL
HCMPROD	asm_diskstring	NULL	YES	disk set locations for discovery	NO	YES	FALSE	NULL
HCMPROD	asm_power_limit	1	YES	number of processes for disk rebalancing	YES	YES	FALSE	NULL
HCMPROD	audit_file_dest	/oracle/admin/HCMPROD/adump	YES	Directory in which auditing files are to reside	NO	YES	TRUE	NULL
HCMPROD	audit_sys_operations	FALSE	YES	enable sys auditing	NO	NO	FALSE	NULL
HCMPROD	audit_syslog_level	NULL	YES	Syslog facility and level	NO	NO	FALSE	NULL
HCMPROD	audit_trail	TRUE	NO	enable system auditing	NO	NO	FALSE	if you want auditing
HCMPROD	background_core_dump	partial	YES	Core Size for Background Processes	NO	NO	FALSE	NULL
HCMPROD	background_dump_dest	/oracle/admin/HCMPROD/bdump	NO	Detached process dump directory	NO	YES	FALSE	NULL
HCMPROD	backup_tape_io_slaves	FALSE	YES	BACKUP Tape I/O slaves	NO	YES	TRUE	NULL
HCMPROD	bitmap_merge_area_size	1048576	YES	maximum memory allow for BITMAP MERGE	NO	NO	FALSE	NULL
HCMPROD	blank_trimming	FALSE	YES	blank trimming semantics parameter	NO	NO	FALSE	NULL
HCMPROD	buffer_pool_keep	NULL	YES	Number of database blocks/latches in keep buffer pool	NO	NO	FALSE	NULL
HCMPROD	buffer_pool_recycle	NULL	YES	Number of database blocks/latches in recycle buffer pool	NO	NO	FALSE	NULL
HCMPROD	circuits	NULL	YES	max number of circuits	NO	YES	FALSE	NULL
HCMPROD	cluster_database	FALSE	YES	if TRUE startup in cluster database mode	NO	NO	FALSE	NULL
HCMPROD	cluster_database_instances	1	YES	number of instances to use for sizing cluster db SGA structures	NO	NO	FALSE	NULL
HCMPROD	cluster_interconnects	NULL	YES	interconnects for RAC use	NO	NO	FALSE	NULL
HCMPROD	commit_point_strength	1	YES	Bias this node has toward not preparing in a two-phase commit	NO	NO	FALSE	NULL
HCMPROD	commit_write	NULL	YES	transaction commit log write behaviour	YES	YES	FALSE	NULL
HCMPROD	compatible	10.2.0.3.0	NO	Database will be completely compatible with this software versio	NO	NO	FALSE	NULL
HCMPROD	control_file_record_keep_time	40	NO	control file record keep time in days	NO	YES	FALSE	NULL
HCMPROD	control_files	/HCMPROD01/control01.ctl, /HCMPROD01/control02.ctl, /HCMPROD01/control03.ctl	NO	control file names list	NO	NO	FALSE	NULL
HCMPROD	core_dump_dest	/oracle/admin/HCMPROD/cdump	NO	Core dump directory	NO	YES	FALSE	NULL
HCMPROD	cpu_count	32	YES	number of CPUs for this instance	NO	YES	FALSE	NULL
HCMPROD	create_bitmap_area_size	8388608	YES	size of create bitmap buffer for bitmap index	NO	NO	FALSE	NULL
HCMPROD	create_stored_outlines	NULL	YES	create stored outlines for DML statements	YES	YES	FALSE	NULL
HCMPROD	cursor_sharing	exact	NO	cursor sharing mode	YES	YES	FALSE	NULL
HCMPROD	cursor_space_for_time	FALSE	YES	use more memory in order to get faster execution	NO	NO	FALSE	NULL
HCMPROD	db_16k_cache_size	0	YES	Size of cache for 16K buffers	NO	YES	FALSE	NULL
HCMPROD	db_2k_cache_size	0	YES	Size of cache for 2K buffers	NO	YES	FALSE	NULL
HCMPROD	db_32k_cache_size	0	YES	Size of cache for 32K buffers	NO	YES	FALSE	NULL
HCMPROD	db_4k_cache_size	0	YES	Size of cache for 4K buffers	NO	YES	FALSE	NULL
HCMPROD	db_8k_cache_size	0	YES	Size of cache for 8K buffers	NO	YES	FALSE	NULL
HCMPROD	db_block_buffers	0	YES	Number of database blocks cached in memory	NO	NO	FALSE	NULL
HCMPROD	db_block_checking	FALSE	YES	header checking and data and index block checking	YES	YES	FALSE	NULL
HCMPROD	db_block_checksum	TRUE	YES	store checksum in db blocks and check during reads	NO	YES	FALSE	NULL
HCMPROD	db_block_size	8192	NO	Size of database block in bytes	NO	NO	FALSE	NULL
HCMPROD	db_cache_advice	ON	YES	Buffer cache sizing advisory	NO	YES	FALSE	NULL
HCMPROD	db_cache_size	0	YES	Size of DEFAULT buffer pool for standard block size buffers	NO	YES	FALSE	NULL
HCMPROD	db_create_file_dest	NULL	YES	default database location	YES	YES	FALSE	NULL
HCMPROD	db_create_online_log_dest_1	NULL	YES	online log/controlfile destination #1	YES	YES	FALSE	NULL
HCMPROD	db_create_online_log_dest_2	NULL	YES	online log/controlfile destination #2	YES	YES	FALSE	NULL
HCMPROD	db_create_online_log_dest_3	NULL	YES	online log/controlfile destination #3	YES	YES	FALSE	NULL
HCMPROD	db_create_online_log_dest_4	NULL	YES	online log/controlfile destination #4	YES	YES	FALSE	NULL
HCMPROD	db_create_online_log_dest_5	NULL	YES	online log/controlfile destination #5	YES	YES	FALSE	NULL
HCMPROD	db_domain	ceg.corp.net	NO	directory part of global database name stored with CREATE DATABA	NO	NO	FALSE	NULL
HCMPROD	db_file_multiblock_read_count	16	NO	db block to be read each IO	YES	YES	FALSE	NULL
HCMPROD	db_file_name_convert	NULL	YES	datafile name convert patterns and strings for standby/clone db	YES	NO	FALSE	NULL
HCMPROD	db_files	1021	NO	max allowable # db files	NO	NO	FALSE	LARGE
HCMPROD	db_flashback_retention_target	1440	YES	Maximum Flashback Database log retention time in minutes.	NO	YES	FALSE	NULL
HCMPROD	db_keep_cache_size	0	YES	Size of KEEP buffer pool for standard block size buffers	NO	YES	FALSE	NULL
HCMPROD	db_name	HCMPROD	NO	database name specified in CREATE DATABASE	NO	NO	FALSE	NULL
HCMPROD	db_recovery_file_dest	NULL	YES	default database recovery file location	NO	YES	FALSE	NULL
HCMPROD	db_recovery_file_dest_size	0	YES	database recovery files size limit	NO	YES	FALSE	NULL
HCMPROD	db_recycle_cache_size	0	YES	Size of RECYCLE buffer pool for standard block size buffers	NO	YES	FALSE	NULL
HCMPROD	db_unique_name	HCMPROD	YES	Database Unique Name	NO	NO	FALSE	NULL
HCMPROD	db_writer_processes	4	YES	number of background database writer processes to start	NO	NO	FALSE	NULL
HCMPROD	dbwr_io_slaves	0	YES	DBWR I/O slaves	NO	NO	FALSE	NULL
HCMPROD	ddl_wait_for_locks	FALSE	YES	Disable NOWAIT DML lock acquisitions	YES	YES	FALSE	NULL
HCMPROD	dg_broker_config_file1	/oracle/product/10.2.0.3ps/dbs/dr1HCMPROD.dat	YES	data guard broker configuration file #1	NO	YES	FALSE	NULL
HCMPROD	dg_broker_config_file2	/oracle/product/10.2.0.3ps/dbs/dr2HCMPROD.dat	YES	data guard broker configuration file #2	NO	YES	FALSE	NULL
HCMPROD	dg_broker_start	FALSE	YES	start Data Guard broker framework (DMON process)	NO	YES	FALSE	NULL
HCMPROD	disk_asynch_io	TRUE	YES	Use asynch I/O for random access devices	NO	NO	FALSE	NULL
HCMPROD	dispatchers	NULL	YES	specifications of dispatchers	NO	YES	FALSE	NULL
HCMPROD	distributed_lock_timeout	60	YES	number of seconds a distributed transaction waits for a lock	NO	NO	FALSE	NULL
HCMPROD	dml_locks	1472	YES	dml locks - one for each table modified in a transaction	NO	NO	FALSE	NULL
HCMPROD	drs_start	FALSE	YES	start DG Broker monitor (DMON process)	NO	YES	FALSE	NULL
HCMPROD	event	NULL	YES	debug event control - default null string	NO	NO	FALSE	NULL
HCMPROD	fal_client	NULL	YES	FAL client	NO	YES	FALSE	NULL
HCMPROD	fal_server	NULL	YES	FAL server list	NO	YES	FALSE	NULL
HCMPROD	fast_start_io_target	0	YES	Upper bound on recovery reads	NO	YES	FALSE	NULL
HCMPROD	fast_start_mttr_target	0	YES	MTTR target of forward crash recovery in seconds	NO	YES	FALSE	NULL
HCMPROD	fast_start_parallel_rollback	LOW	YES	max number of parallel recovery slaves that may be used	NO	YES	FALSE	NULL
HCMPROD	file_mapping	FALSE	YES	enable file mapping	NO	YES	FALSE	NULL
HCMPROD	fileio_network_adapters	NULL	YES	Network Adapters for File I/O	NO	NO	FALSE	NULL
HCMPROD	filesystemio_options	asynch	YES	IO operations on filesystem files	NO	NO	FALSE	NULL
HCMPROD	fixed_date	NULL	YES	fixed SYSDATE value	NO	YES	FALSE	NULL
HCMPROD	gc_files_to_locks	NULL	YES	mapping between file numbers and global cache locks	NO	NO	FALSE	NULL
HCMPROD	gcs_server_processes	0	YES	number of background gcs server processes to start	NO	NO	FALSE	NULL
HCMPROD	global_context_pool_size	NULL	YES	Global Application Context Pool Size in Bytes	NO	NO	FALSE	NULL
HCMPROD	global_names	FALSE	YES	enforce that database links have same name as remote database	YES	YES	FALSE	NULL
HCMPROD	hash_area_size	4194304	YES	size of in-memory hash work area	YES	NO	FALSE	NULL
HCMPROD	hi_shared_memory_address	0	YES	SGA starting address (high order 32-bits on 64-bit platforms)	NO	NO	FALSE	NULL
HCMPROD	hs_autoregister	TRUE	YES	enable automatic server DD updates in HS agent self-registration	NO	YES	FALSE	NULL
HCMPROD	ifile	NULL	YES	include file in init.ora	NO	NO	FALSE	NULL
HCMPROD	instance_groups	NULL	YES	list of instance group names	NO	NO	FALSE	NULL
HCMPROD	instance_name	HCMPROD	NO	instance name supported by the instance	NO	NO	FALSE	NULL
HCMPROD	instance_number	0	YES	instance number	NO	NO	FALSE	NULL
HCMPROD	instance_type	RDBMS	YES	type of instance to be executed	NO	NO	FALSE	NULL
HCMPROD	java_max_sessionspace_size	0	YES	max allowed size in bytes of a Java sessionspace	NO	NO	FALSE	NULL
HCMPROD	java_pool_size	0	YES	size in bytes of java pool	NO	YES	FALSE	NULL
HCMPROD	java_soft_sessionspace_limit	0	YES	warning limit on size in bytes of a Java sessionspace	NO	NO	FALSE	NULL
HCMPROD	job_queue_processes	4	NO	number of job queue slave processes	NO	YES	FALSE	NULL
HCMPROD	large_pool_size	0	YES	size in bytes of large pool	NO	YES	FALSE	NULL
HCMPROD	ldap_directory_access	NONE	YES	RDBMS's LDAP access option	NO	YES	FALSE	NULL
HCMPROD	license_max_sessions	0	YES	maximum number of non-system user sessions allowed	NO	YES	FALSE	NULL
HCMPROD	license_max_users	0	YES	maximum number of named users that can be created in the databas	NO	YES	FALSE	NULL
HCMPROD	license_sessions_warning	0	YES	warning level for number of non-system user sessions	NO	YES	FALSE	NULL
HCMPROD	local_listener	NULL	YES	local listener	NO	YES	FALSE	NULL
HCMPROD	lock_name_space	NULL	YES	lock name space used for generating lock names for standby/clone	NO	NO	FALSE	NULL
HCMPROD	lock_sga	FALSE	YES	Lock entire SGA in physical memory	NO	NO	FALSE	NULL
HCMPROD	log_archive_config	NULL	YES	log archive config parameter	NO	YES	FALSE	NULL
HCMPROD	log_archive_dest	NULL	YES	archival destination text string	NO	YES	FALSE	NULL
HCMPROD	log_archive_dest_1	location=/oracle/admin/HCMPROD/arch/	NO	archival destination #1 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_10	NULL	YES	archival destination #10 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_2	SERVICE=HCMPRODSB AFFIRM LGWR SYNC=parallel REOPEN=60 NOMAX_FAILURE VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE)	YES	archival destination #2 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_3	NULL	YES	archival destination #3 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_4	NULL	YES	archival destination #4 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_5	NULL	YES	archival destination #5 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_6	NULL	YES	archival destination #6 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_7	NULL	YES	archival destination #7 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_8	NULL	YES	archival destination #8 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_9	NULL	YES	archival destination #9 text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_1	enable	YES	archival destination #1 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_10	enable	YES	archival destination #10 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_2	ENABLE	YES	archival destination #2 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_3	enable	YES	archival destination #3 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_4	enable	YES	archival destination #4 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_5	enable	YES	archival destination #5 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_6	enable	YES	archival destination #6 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_7	enable	YES	archival destination #7 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_8	enable	YES	archival destination #8 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_dest_state_9	enable	YES	archival destination #9 state text string	YES	YES	FALSE	NULL
HCMPROD	log_archive_duplex_dest	NULL	YES	duplex archival destination text string	NO	YES	FALSE	NULL
HCMPROD	log_archive_format	HCMPROD_%t_%s_%r.dbf	NO	archival destination format	NO	NO	FALSE	NULL
HCMPROD	log_archive_local_first	TRUE	YES	Establish EXPEDITE attribute default value	NO	YES	FALSE	NULL
HCMPROD	log_archive_max_processes	2	YES	maximum number of active ARCH processes	NO	YES	FALSE	NULL
HCMPROD	log_archive_min_succeed_dest	1	YES	minimum number of archive destinations that must succeed	YES	YES	FALSE	NULL
HCMPROD	log_archive_start	FALSE	YES	start archival process on SGA initialization	NO	NO	FALSE	NULL
HCMPROD	log_archive_trace	0	YES	Establish archivelog operation tracing level	NO	YES	FALSE	NULL
HCMPROD	log_buffer	2097152	NO	redo circular buffer size	NO	NO	FALSE	NULL
HCMPROD	log_checkpoint_interval	50000	NO	# redo blocks checkpoint threshold	NO	YES	FALSE	NULL
HCMPROD	log_checkpoint_timeout	1800	YES	Maximum time interval between checkpoints in seconds	NO	YES	FALSE	NULL
HCMPROD	log_checkpoints_to_alert	TRUE	NO	log checkpoint begin/end to alert file	NO	YES	FALSE	NULL
HCMPROD	log_file_name_convert	NULL	YES	logfile name convert patterns and strings for standby/clone db	NO	NO	FALSE	NULL
HCMPROD	logmnr_max_persistent_sessions	1	YES	maximum number of threads to mine	NO	NO	FALSE	NULL
HCMPROD	max_commit_propagation_delay	0	YES	Max age of new snapshot in .01 seconds	NO	NO	FALSE	NULL
HCMPROD	max_dispatchers	NULL	YES	max number of dispatchers	NO	YES	FALSE	NULL
HCMPROD	max_dump_file_size	5000000	NO	Maximum size (blocks) of dump file	YES	YES	FALSE	limit trace file size to 5M each
HCMPROD	max_enabled_roles	150	YES	max number of roles a user can have enabled	NO	NO	FALSE	NULL
HCMPROD	max_shared_servers	NULL	YES	max number of shared servers	NO	YES	FALSE	NULL
HCMPROD	object_cache_max_size_percent	10	YES	percentage of maximum size over optimal of the user session's ob	YES	YES	TRUE	NULL
HCMPROD	object_cache_optimal_size	102400	YES	optimal size of the user session's object cache in bytes	YES	YES	TRUE	NULL
HCMPROD	olap_page_pool_size	0	YES	size of the olap page pool in bytes	YES	YES	TRUE	NULL
HCMPROD	open_cursors	255	NO	max # cursors per session	NO	YES	FALSE	NULL
HCMPROD	open_links	100	NO	max # open links per session	NO	NO	FALSE	NULL
HCMPROD	open_links_per_instance	4	YES	max # open links per instance	NO	NO	FALSE	NULL
HCMPROD	optimizer_dynamic_sampling	2	YES	optimizer dynamic sampling	YES	YES	FALSE	NULL
HCMPROD	optimizer_features_enable	10.2.0.3	YES	optimizer plan compatibility parameter	YES	YES	FALSE	NULL
HCMPROD	optimizer_index_caching	0	YES	optimizer percent index caching	YES	YES	FALSE	NULL
HCMPROD	optimizer_index_cost_adj	100	YES	optimizer index cost adjustment	YES	YES	FALSE	NULL
HCMPROD	optimizer_mode	CHOOSE	NO	optimizer mode	YES	YES	FALSE	NULL
HCMPROD	optimizer_secure_view_merging	TRUE	YES	optimizer secure view merging and predicate pushdown/movearound	NO	YES	FALSE	NULL
HCMPROD	os_authent_prefix	ops$	YES	prefix for auto-logon accounts	NO	NO	FALSE	NULL
HCMPROD	os_roles	FALSE	YES	retrieve roles from the operating system	NO	NO	FALSE	NULL
HCMPROD	parallel_adaptive_multi_user	TRUE	YES	enable adaptive setting of degree for multiple user streams	NO	YES	FALSE	NULL
HCMPROD	parallel_automatic_tuning	FALSE	YES	enable intelligent defaults for parallel execution parameters	NO	NO	FALSE	NULL
HCMPROD	parallel_execution_message_size	2152	YES	message buffer size for parallel execution	NO	NO	FALSE	NULL
HCMPROD	parallel_instance_group	NULL	YES	instance group to use for all parallel operations	YES	YES	FALSE	NULL
HCMPROD	parallel_max_servers	285	YES	maximum parallel query servers per instance	NO	YES	FALSE	NULL
HCMPROD	parallel_min_percent	0	YES	minimum percent of threads required for parallel query	YES	NO	FALSE	NULL
HCMPROD	parallel_min_servers	0	YES	minimum parallel query servers per instance	NO	YES	FALSE	NULL
HCMPROD	parallel_server	FALSE	YES	if TRUE startup in parallel server mode	NO	NO	FALSE	NULL
HCMPROD	parallel_server_instances	1	YES	number of instances to use for sizing OPS SGA structures	NO	NO	FALSE	NULL
HCMPROD	parallel_threads_per_cpu	2	YES	number of parallel execution threads per CPU	NO	YES	FALSE	NULL
HCMPROD	pga_aggregate_target	1073741824	NO	Target size for the aggregate PGA memory consumed by the instanc	NO	YES	FALSE	NULL
HCMPROD	plsql_ccflags	NULL	YES	PL/SQL ccflags	YES	YES	FALSE	NULL
HCMPROD	plsql_code_type	INTERPRETED	YES	PL/SQL code-type	YES	YES	FALSE	NULL
HCMPROD	plsql_compiler_flags	INTERPRETED, NON_DEBUG	YES	PL/SQL compiler flags	YES	YES	FALSE	NULL
HCMPROD	plsql_debug	FALSE	YES	PL/SQL debug	YES	YES	FALSE	NULL
HCMPROD	plsql_native_library_dir	NULL	YES	plsql native library dir	NO	YES	FALSE	NULL
HCMPROD	plsql_native_library_subdir_count	0	YES	plsql native library number of subdirectories	NO	YES	FALSE	NULL
HCMPROD	plsql_optimize_level	2	YES	PL/SQL optimize level	YES	YES	FALSE	NULL
HCMPROD	plsql_v2_compatibility	FALSE	YES	PL/SQL version 2.x compatibility flag	YES	YES	FALSE	NULL
HCMPROD	plsql_warnings	DISABLE:ALL	YES	PL/SQL compiler warnings settings	YES	YES	FALSE	PL/SQL warnings at init.ora
HCMPROD	pre_page_sga	FALSE	YES	pre-page sga for process	NO	NO	FALSE	NULL
HCMPROD	processes	300	NO	user processes	NO	NO	FALSE	NULL
HCMPROD	query_rewrite_enabled	TRUE	YES	allow rewrite of queries using materialized views if enabled	YES	YES	FALSE	NULL
HCMPROD	query_rewrite_integrity	enforced	YES	perform rewrite using materialized views with desired integrity	YES	YES	FALSE	NULL
HCMPROD	rdbms_server_dn	NULL	YES	RDBMS's Distinguished Name	NO	NO	FALSE	NULL
HCMPROD	read_only_open_delayed	FALSE	YES	if TRUE delay opening of read only files until first access	NO	NO	FALSE	NULL
HCMPROD	recovery_parallelism	0	YES	number of server processes to use for parallel recovery	NO	NO	FALSE	NULL
HCMPROD	recyclebin	on	YES	recyclebin processing	YES	YES	FALSE	NULL
HCMPROD	remote_archive_enable	true	YES	remote archival enable setting	NO	NO	FALSE	NULL
HCMPROD	remote_dependencies_mode	TIMESTAMP	YES	remote-procedure-call dependencies mode parameter	YES	YES	FALSE	NULL
HCMPROD	remote_listener	NULL	YES	remote listener	NO	YES	FALSE	NULL
HCMPROD	remote_login_passwordfile	EXCLUSIVE	YES	password file usage parameter	NO	NO	FALSE	NULL
HCMPROD	remote_os_authent	TRUE	NO	allow non-secure remote clients to use auto-logon accounts	NO	NO	FALSE	NULL
HCMPROD	remote_os_roles	FALSE	YES	allow non-secure remote clients to use os roles	NO	NO	FALSE	NULL
HCMPROD	replication_dependency_tracking	TRUE	YES	tracking dependency for Replication parallel propagation	NO	NO	FALSE	NULL
HCMPROD	resource_limit	FALSE	YES	master switch for resource limit	NO	YES	FALSE	NULL
HCMPROD	resource_manager_plan	NULL	YES	resource mgr top plan	NO	YES	FALSE	NULL
HCMPROD	resumable_timeout	0	YES	set resumable_timeout	YES	YES	FALSE	NULL
HCMPROD	rollback_segments	NULL	YES	undo segment list	NO	NO	FALSE	NULL
HCMPROD	serial_reuse	disable	YES	reuse the frame segments	NO	NO	FALSE	NULL
HCMPROD	service_names	HCMPROD	NO	service names supported by the instance	NO	YES	FALSE	NULL
HCMPROD	session_cached_cursors	250	NO	Number of cursors to cache in a session.	YES	NO	FALSE	NULL
HCMPROD	session_max_open_files	10	YES	maximum number of open files allowed per session	NO	NO	FALSE	NULL
HCMPROD	sessions	335	YES	user and system sessions	NO	NO	FALSE	NULL
HCMPROD	sga_max_size	2634022912	NO	max total SGA size	NO	NO	FALSE	internally adjusted
HCMPROD	sga_target	2634022912	NO	Target size of SGA	NO	YES	FALSE	NULL
HCMPROD	shadow_core_dump	partial	YES	Core Size for Shadow Processes	NO	NO	FALSE	NULL
HCMPROD	shared_memory_address	0	YES	SGA starting address (low order 32-bits on 64-bit platforms)	NO	NO	FALSE	NULL
HCMPROD	shared_pool_reserved_size	26004684	YES	size in bytes of reserved area of shared pool	NO	NO	FALSE	NULL
HCMPROD	shared_pool_size	0	YES	size in bytes of shared pool	NO	YES	FALSE	NULL
HCMPROD	shared_server_sessions	NULL	YES	max number of shared server sessions	NO	YES	FALSE	NULL
HCMPROD	shared_servers	0	YES	number of shared servers to start up	NO	YES	FALSE	NULL
HCMPROD	skip_unusable_indexes	TRUE	YES	skip unusable indexes if set to TRUE	YES	YES	FALSE	NULL
HCMPROD	smtp_out_server	NULL	YES	utl_smtp server and port configuration parameter	YES	YES	FALSE	NULL
HCMPROD	sort_area_retained_size	2097152	NO	size of in-memory sort work area retained between fetch calls	YES	YES	TRUE	NULL
HCMPROD	sort_area_size	2097152	NO	size of in-memory sort work area	YES	YES	TRUE	NULL
HCMPROD	spfile	NULL	YES	server parameter file	NO	NO	FALSE	NULL
HCMPROD	sql92_security	FALSE	YES	require select privilege for searched update/delete	NO	NO	FALSE	NULL
HCMPROD	sql_trace	FALSE	YES	enable SQL trace	YES	YES	FALSE	NULL
HCMPROD	sql_version	NATIVE	YES	sql language version parameter for compatibility issues	YES	NO	FALSE	NULL
HCMPROD	sqltune_category	DEFAULT	YES	Category qualifier for applying hintsets	YES	YES	FALSE	NULL
HCMPROD	standby_archive_dest	?/dbs/arch	YES	standby database archivelog destination text string	NO	YES	FALSE	NULL
HCMPROD	standby_file_management	MANUAL	YES	if auto then files are created/dropped automatically on standby	NO	YES	FALSE	NULL
HCMPROD	star_transformation_enabled	FALSE	YES	enable the use of star transformation	YES	YES	FALSE	NULL
HCMPROD	statistics_level	TYPICAL	NO	statistics level	YES	YES	FALSE	NULL
HCMPROD	streams_pool_size	67108864	NO	size in bytes of the streams pool	NO	YES	FALSE	NULL
HCMPROD	tape_asynch_io	TRUE	YES	Use asynch I/O requests for tape devices	NO	NO	FALSE	NULL
HCMPROD	thread	0	YES	Redo thread to mount	NO	YES	FALSE	NULL
HCMPROD	timed_os_statistics	0	YES	internal os statistic gathering interval in seconds	YES	YES	FALSE	NULL
HCMPROD	timed_statistics	TRUE	NO	maintain internal timing statistics	YES	YES	FALSE	NULL
HCMPROD	trace_enabled	TRUE	YES	enable KST tracing	NO	YES	FALSE	NULL
HCMPROD	tracefile_identifier	NULL	YES	trace file custom identifier	YES	NO	FALSE	NULL
HCMPROD	transactions	368	YES	max. number of concurrent active transactions	NO	NO	FALSE	NULL
HCMPROD	transactions_per_rollback_segment	5	YES	number of active transactions per rollback segment	NO	NO	FALSE	NULL
HCMPROD	undo_management	AUTO	NO	instance runs in SMU mode if TRUE, else in RBU mode	NO	NO	FALSE	Changed for parallel testing 1/25/2004
HCMPROD	undo_retention	14400	NO	undo retention in seconds	NO	YES	FALSE	NULL
HCMPROD	undo_tablespace	UNDORBS	NO	use/switch undo tablespace	NO	YES	FALSE	NULL
HCMPROD	use_indirect_data_buffers	FALSE	YES	Enable indirect data buffers (very large SGA on 32-bit platforms	NO	NO	FALSE	NULL
HCMPROD	user_dump_dest	/oracle/admin/HCMPROD/udump	NO	User process dump directory	NO	YES	FALSE	NULL
HCMPROD	utl_file_dir	NULL	YES	utl_file accessible directories list	NO	NO	FALSE	NULL
HCMPROD	workarea_size_policy	AUTO	YES	policy used to size SQL working areas (MANUAL/AUTO)	YES	YES	FALSE	NULL

 

>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee.  If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2