Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> init.ora Parameter in 8.1.6 and 7.3.4 ((Help!!!))

init.ora Parameter in 8.1.6 and 7.3.4 ((Help!!!))

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 10 Aug 2001 02:20:40 -0700
Message-ID: <93f65984.0108100120.27f808ac@posting.google.com>

dear all,

I am upgrading our database from 7.3.4 to 8.1.6. I found out that there are some parameters in 7.3.4 but not in 8.1.6 and vic versa. Following is some parameter in 7.3.4 but not in 8.1.6.



background_dump_dest = /vol2/app/oracle/admin/P8/bdump
core_dump_dest		= /vol2/app/oracle/admin/P8/cdump
user_dump_dest		= /vol2/app/oracle/admin/P8/udump
#db_block_size		= <blocksize>

dml_locks = 1000                                              
sequence_cache_entries = 100
sequence_cache_hash_buckets = 89                               
open_cursors               =  400
max_enabled_roles          =  100
optimizer_mode             =  rule
job_queue_processes        = 6    # three background processes
job_queue_interval         = 10   # the processes wake up every 10
seconds
job_queue_keep_connections = TRUE # sleep, don't disconnect

UTL_FILE_DIR = /usr/tmp


Are those important? Should I add them in my init file? Please clarify.
Thanks in advance,

JK Received on Fri Aug 10 2001 - 04:20:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US