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: Tuning Financials on NT

Re: Tuning Financials on NT

From: Jared Hecker <jared_at_pandora.planet.net>
Date: 1 Sep 1998 19:07:16 GMT
Message-ID: <6shgl4$oj@jupiter.planet.net>


A big performance pickup is possible depending on how many concurrent users you have. If the number is small - say 20 or less - do *not* pin the packages in memory as per the installation instructions. Noticeable improvement if you give that memory to the data buffers instead. Even if you leave the SGA alone you should see better performance.

hth -

Regards,
jh

Nuno Souto (nsouto_at_acay.com.au) wrote:
: robbiel_at_my-dejanews.com wrote:
: >
: > I think that the RAID5 isn't implemeted in the right way (logfiles,archived
: > logfiles and temorary tablespace on RAID5) and that I am having
: > problems with IO how can I check the performance of these RAID drives ( In
: > Oracle or NT )

: RAID5 is not good for keeping the online log files. Put them in a RAID1
: partition (striped) and use the inbuilt mirroring in ORACLE to safekeep
: them (you may need 2 RAID1 partitions). Missing that, put them in a NTFS
: or FAT partition but not in RAID5.

: This will not improve the performance dramatically. You'r better off
: looking at what is running via CM and how well tuned the code is, rather
: than fiddling with the hardware. You stand to gain more.

: HTH
: --
: Cheers
: Nuno Souto
: D.C.S. P/L
: e-mail: nsouto_at_acay.com.au

--

Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **
Received on Tue Sep 01 1998 - 14:07:16 CDT

Original text of this message

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