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

Lots of parameters do not need to be in the init.ora file. But they are still there using default value. If you need to specify a new value, you can include them in the init.ora.

If you have you 8.1.6 up, type show parameter, it will show you all.

Xiaobin

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0108100120.27f808ac_at_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 - 08:12:22 CDT