Re: Q:Good preformance

On 12 Sep 1997 15:38:07 GMT, "Marre" <marre_at_mbox306.swipnet.se> wrote:

>Hello
>I've got the following INIT.ORA file, does anybody know who I can
>tune the INIT.ORA file for best preformance. I've got lots of inserts and
>updates in my applikation.
>
>//Martin
>
>############################################################################
>###
>
>db_name = NAME
>db_files = 100
>control_files = VOL4:idok\ctl1.ctl,
> VOL1:dbcopy\idok\ctl2.ctl
>
>
>ROLLBACK_SEGMENTS=(RB1,RB2,RB3,rb4,rb5,rb6,rb7,rb8,rb9,rb10,rb11,rb12,rb13,r
>b14,rb15,rb16)

Ah! There's your problem - should not be using rb7 there... Only Joking!

What you are asking is not possible. No one can tune your instance from this information. Please review the Oracle Performance Tuning Guide for the steps you need to take to get optimum performance from your application and database.

>
>compatible = 7.3.2.0.0
>
>db_file_multiblock_read_count = 8 # INITIAL
># db_file_multiblock_read_count = 8 #
>SMALL

 [snip]
>background_dump_dest=vol4:idok\trace
>user_dump_dest=vol4:idok\trace
>
>db_block_size = 4096
>
>remote_login_passwordfile = shared
>
>os_authent_prefix = ""
># os_roles = true
>
># See release notes for the description of the event
>event = " 10805 trace name context forever, level 1 "
>
># Lite parametrar
>
>dml_locks = 1200
>optimizer_mode = rule
>job_queue_processes = 3 # tree background processes
>job_queue_interval = 30 # the processes wake up every 30 seconds
>job_queue_keep_connections = TRUE # sleep, don't disconnect
>
>############################################################################
>###
>

my views only....disclaimer

David Sidwell Received on Fri Sep 12 1997 - 00:00:00 CDT