Oracle Performance Problem

[Eldrik]

Hi,

a short introduction what i got. I got an Testsystem and a Produktivsystem on both are working the both application to write data in the database.

trough Indixies i got more performance then before , but also on both system are the same Hardware and the same changes (eg. Indixies) made by me, the produktivsystem needs 3 hours to write data in the database the testsystem only 30 minutes

The Databases wasn´t set up by me.

On my database where slower Hardware and the settings are little it took ca. 40 minutes to write data in database.
My question ist what can i do to find the problem that makes the prouktivsystem so slow?
Here are the SGA SETTINGS of both systems.

Produktivsystem ------- Testsystem
Shared Pool = 355 MB ------ 160 MB
Buffer Cache = 1066 MB ------- 481 MB
Large Pool = 11 MB ------- 11 MB
Java Pool = 32kb ------- 32 kb
Total = 1433.9049 ------- 653.6968

Max Users = 700 700

Does anyone knows the answer??

Greetz
Eldrik

[gandolf989]

You need to look at the performance on your raid. If you set up a test system with one or two non-striped disks, then the write performance might be pretty good. Especially if you are using fast scsi and or 10,000 prm disk drives. If your raid controller is slow, or the disk drives are slow or if you are getting errors on the disk drives of your production system any of this will cause you performance problems. There is a write penalty on raid systems as the disks are writing to multiple locations. This is usually balanced out by a quicker read. So you need to look at you storage system. What kind of raid are you doing on production? Are you doing a software raid or is it a hardware raid? What kind of hardware do you have? How fast are your disk drives? What is your os? Can you run some kind of disk utility to check the consistancy of your storage system?

Take a look at the above and you will probably find your answer.

[Eldrik]

Hi,

Hardware are the same (eg. Raid) on both Systems.
I will check if there is a problem with the storage.

Greetz
Eldrik

[slimdave]

what do you mean by "write data in the database"

[Orca777]

Hi, SGA should be no problem
What is the different about the amount of data

PROD :
TEST :

* if your tables are intesive indexed then oracle has to read a lot of blocks too;

* What is with freelist-param in the table

* look in the waitstat-tables v$session_wait what the prblem could be

* are the redologs same positioned as in test-environment

* size of log_buffer

* Number log-switches

* is your prod-db on archive-log mode ore not?

Some brainstorming

Orca

[Eldrik]

Hi,

problem fixed

I changed some part of large_pool_size.

Also i did another Analyse Job on the Db.

Otherwise the whole System had to reboot cause there was a problem with some of the software might be an OS failure.

Today i check the logfiles of our Software an the time is exactly like on the Testsystem.

I don´t know if it was an problem the machine it selfs.

Greetz
Eldrik