O7_DICTIONARY_ACCESSIBILITY=TRUE *.background_dump_dest='e:\ORACLE\admin\LAKMINS\bdump' compatible='9.2.0.8.0' *.control_files='e:\ORACLE\oradata\LAKMINS\control01.ctl','e:\ORACLE\oradata\LAKMINS\control02.ctl','e:\ORACLE\oradata\LAKMINS\control03.ctl' *.core_dump_dest='e:\ORACLE\admin\LAKMINS\cdump' ##cursor_sharing=force ##optimizer_index_cost_adj=10 db_block_size=8192 db_block_buffers=262144 ##db_block_buffers=131072 use_indirect_data_buffers=true db_domain='' db_file_multiblock_read_count=32 db_writer_processes=4 db_name='LAKMINS' fast_start_mttr_target=300 hash_join_enabled=FALSE instance_name='LAKMINS' java_pool_size=16777216 large_pool_size=0 log_buffer=20971520 pga_aggregate_target=201326592 workarea_size_policy=auto open_cursors=1000 processes=800 ##query_rewrite_enabled=true ##query_rewrite_integrity=trusted remote_login_passwordfile='EXCLUSIVE' ##shared_pool_size=402653184 shared_pool_size=201326592 star_transformation_enabled='FALSE' timed_statistics=FALSE undo_management='AUTO' undo_retention=10800 undo_tablespace='UNDOTBS1' *.user_dump_dest='e:\ORACLE\admin\LAKMINS\udump' ## PARALLEL ## #CPU_COUNT=8 #PARALLEL_AUTOMATIC_TUNING=TRUE #parallel_min_servers=16 #parallel_max_servers=128 #parallel_threads_per_cpu=4 parallel_max_servers=0 job_queue_processes=1 resource_limit=true