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

"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

I disagree with the previous answer, as I would have probably copied my own init.ora to the 8.1.6 location
That said I will comment on each of them

> background_dump_dest = /vol2/app/oracle/admin/P8/bdump

definitely needs to be in

> core_dump_dest = /vol2/app/oracle/admin/P8/cdump
 ditto
> user_dump_dest = /vol2/app/oracle/admin/P8/udump

ditto
> #db_block_size = <blocksize>

I assume you already have one
>
> dml_locks = 1000

big!

> sequence_cache_entries = 100
> sequence_cache_hash_buckets = 89
> open_cursors = 400
> max_enabled_roles = 100
 

> optimizer_mode = rule

Stupid, you force all your applications to use Rule based optimizer, thus forcing your apps in 2001 to use technology from 1993

> job_queue_processes = 6 # three background processes

The comment is incorrect. The number is exact, and way to high
> job_queue_interval = 10 # the processes wake up every 10
> seconds

This will put a severe strain on the system, and you might not even be capable of shutting it down
> job_queue_keep_connections = TRUE # sleep, don't disconnect
>
> UTL_FILE_DIR = /usr/tmp

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 10 2001 - 10:18:15 CDT