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: Please help with performance problem

Re: Please help with performance problem

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/11/21
Message-ID: <653aqh$cbq$1@news01.btx.dtag.de>#1/1

Gena wrote:
>
> Hi.
>
> I am trying to tune an Oracle 7.3.3 running on an NT 4 server.
> This machine has 256Megs of Memory and dual 200MHZ processors.
> This machine is completely dedicated to Oracle and never has anything
> else running.
>
> I have been trying to tune it few a few days now.
> The selects seem to work fine, but updates, deletes and especially
> inserts seem to take much longer than I would think they should on such
> a machine.
>
> To insert 2500 records on a 4 field table (which has only about 2000
> records) takes 45 seconds to a minute.
> To update or delete the same # of records (the delete criteria is on an
> indexed field) takes 30-40 seconds.
> Basically, every operation that does any database changes seems to kill
> performance.
>
> I am trying anything I can think of to improve this performance but
> nothing seems to be working.
>
> The Data, indexes, and rollback tablespaces are all on separate drives.

Do also have the online and archive redologs on separate drives?

>
> I have rebuilt the database with the following initorcl parameters:
>
> I changes all initorcl parameters to those of a Large Database, I also
> set
> cpu_count=2
> db_block_size=8192 (the maximum allowed on NT)
> shared_pool_size=12000000
> pre_page_sga = True (to ensure the entire SGA will be in memory)
>
> Then I rebuilt the database.
>
> I saw little if any improvement in performance (from the default install
>
> configuration) after the rebuild.
>
> Can somebody please tell me if I'm missing any important parameters to
> improve
> performance, or has any other suggestions, or best of all if someone has
> a similar
> hardware setup, can I please see you initorcl file.
>
> any help would be GREATLY appreciated..........
 

-- 
Regards

Matthias Gresz    :-)
Received on Fri Nov 21 1997 - 00:00:00 CST

Original text of this message

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