Re: oracle 7.3 server: performance problem with new dual proz hardware

It looks like you have a potential for an I/O bottlenect. All your data spread across 2 drives and Also you are in Archive Mode.

This is the only thing I can see without knowing your database.

Satar

Ps. You're probally having problems because you're on NT! (UNIX bigots unite!)

In article <364c4b90.0_at_news.piro.net>,
  "uwe fechner" <u.fechner_at_integrata.de.nospäm> wrote:
> hello,
>
> we are running a small, 5g big, database with oracle 7.3. under nt server
> 4.0 sp3.
> we first used an p133 with 64MB. this was slow.
> now we use an dualproz pentium II with 300MHZ, 512 MB and 2 9gig scsi
> drives.
> the database server is connected to the web/app server by an seperate
> fastethernet line.
> this is slower as the old configuration.
> nt has with the new hardware nearly 5 - 10 times the performance of the old
> hardware.
> oracle detects the 2 prozessors.
> we increased the amount of shared memory
>
> here is a part of the config:
> compatible = 7.3.0.0.0
> db_file_multiblock_read_count = 32 #
> LARGE / MOG
> db_block_buffers = 4500 # MOG
> shared_pool_size = 350000000 #
> feu/mog 14.10.98
> log_checkpoint_interval = 10000
> dml_locks = 500 #
> LARGE
> log_buffer = 8192 #
> INITIAL
> sequence_cache_entries = 100 #
> LARGE
> sequence_cache_hash_buckets = 89 #
> LARGE
> max_dump_file_size = 10240 # limit trace file size to 5 Meg each
> log_archive_start = true # if you want automatic archiving
> log_archive_dest = c:\orant\archive
> # define directories to store trace and alert files
> background_dump_dest=%RDBMS73%\trace
> user_dump_dest=%RDBMS73%\trace
> db_block_size = 2048
> snapshot_refresh_processes = 1
> remote_login_passwordfile = shared
> text_enable = true
>
> any one an idea ?
>
> greetings from germany
> uwe
> --
>
> Uwe Fechner
>
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°
> `°º¤ø,¸¸,ø¤º°`°º¤ø
>
> u.fechner@integrata.de http://www.integrata.de
> +49 211 96 555 47 Fax: +49 211 96 555 99
> uwe.fechner@pironet.de http://www.koeln.netsurf.de/~uwe.fechner
>
> ¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,
> ø¤º°`°º¤ø¤º°`°º¤ø,
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 13:03:42 CST