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 -> Re: Q:Good preformance

Re: Q:Good preformance

From: <dasidwel_at_SpamAlotNot.us.oracle.com>
Date: 1997/09/12
Message-ID: <3419c7f0.16096552@news.us.oracle.com>#1/1

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

Original text of this message

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