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

dear all,

In our Oracle8.1.6 database, the init parameter file doesn't have parameters- SORT_AREA_SIZE, SORT_AREA_RETAINED_SIZE, DB_BLOCK_LRU_LATCHES ...etc. It misses many parameters. Does that matter?

Our database is about 20GB datafiles in Solaris E420R Server with two 450MHz CUPs, 2GB RAM. What number should I set in SORT_AREA_SIZE, SORT_AREA_RETAINED_SIZE, DB_BLOCK_LRU_LATCHES ...etc. If I don't put it in, any effects?

Seems, I miss many parameters. Could anyone send me the complete required parameters and default settigns?

Please clarify. Thanks a lot.

regards,
JK

"Stephen Bell" <stephen.bell_at_cgi.ca> wrote in message news:<WHTc7.49259$jA2.4284362_at_news20.bellglobal.com>...
> Hi,
>
> This happens with new releases....new parameters are created and older ones
> are dropped.
>
> If you're upgrading to 8.1.6 don't worry about the discontinued parameters
> from 7.3.4
>
> Hope this helps,
> Steve
> "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 Thu Aug 16 2001 - 04:13:54 CDT