Re: Database slowdown

Hi Steve!

Our ERP-software (AM*Production) really speed up, after Steve's advice. The hardware was changed but the speed was not as good as it should be. After Steve's advice it start running, Thank You Steve!

Regards,
Asko Makitalo
ELOMATIC Oy, P.O.BOX 101/Raisionkaari 55, 21201 Raisio, FINLAND Tel. +358-2-443 3311, Fax +358-2-443 3300 http://www.elomatic.com
http://solutions.oracle.com/ Search: Elomatic , and go Advanced Manufacturing Consept,AM*Production planning

-----Original Message-----
From: Steve Adams <steve.adams_at_ixora.com.au> To: 'Asko Makitalo' <asko.makitalo_at_elomatic.com> Date: 30. joulukuuta 1999 9:15
Subject: RE: Database slowdown ! Thank You

Hello Asko,

Please buy a copy of my book (2nd URL below) and post a follow-up message to the newsgroup to let everybody know what the problem was, and how it was fixed.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.com.au/

-----Original Message-----
From: Asko Makitalo [SMTP:asko.makitalo_at_elomatic.com] Sent: Thursday, December 30, 1999 1:00 AM To: Steve Adams
Subject: Re: Database slowdown ! Thank You

Hi Steve,

Thank You very very much.
It really speed up. (Earlier job take 11minuts, now only 6 minuts)

Regards,
Asko Makitalo
ELOMATIC Oy, PL 101/Raisionkaari 55, 21201 Raisio, FINLAND Tel. +358-2-443 3311, Fax +358-2-443 3300 http://www.elomatic.com

-----Original Message-----
From: Steve Adams <steve.adams_at_ixora.com.au> To: 'Asko Makitalo' <asko.makitalo_at_elomatic.com> Date: 29. joulukuuta 1999 5:06
Subject: RE: Database slowdown

Hello Asko,

It is hard to say much here, because you do not have timed_statistics set to true. However, I suggest that you create some much bigger log files, and then drop the little ones that you are presently using. The new log files should 100 times bigger than they are now. In keeping with this change the log_checkpoint_interval parameter should be multiplied by 100 too. It will also help if you set db_block_checkpoint_batch to 16.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.com.au/

-----Original Message-----
From: Asko Makitalo [SMTP:asko.makitalo_at_elomatic.com] Sent: Tuesday, December 28, 1999 11:36 PM To: steve.adams_at_ixora.com.au
Subject: Re: Database slowdown

Hi!

Have You any good ideas for the database tuning ? The report.txt included.
The pc is 500PII 256Mb RAM WinNT with two oracle instances.

Regards,
Asko Makitalo

Asko.Makitalo_at_elomatic.com
ELOMATIC Oy, PL 101/Raisionkaari 55, 21201 Raisio, FINLAND Tel. +358-2-443 3384, Fax +358-2-443 3300 http://www.elomatic.com

Steve Adams wrote in message <3868160b.1005384476_at_news.eagles.bbs.net.au>...
>Hello Faisal,
>
>There are too many options to speculate. When the problem strikes
>again, take a snapshot of the performance statistics with the Oracle
>utlbstat.sql and utlestat.sql scripts, and then post the report.txt
>file here.
>
>Regards,
>Steve Adams
>http://www.ixora.com.au/
>http://www.oreilly.com/catalog/orinternals/
>http://www.christianity.com.au/
>
>
>On Mon, 27 Dec 1999 07:20:58 GMT, faisal_qasim_at_writeme.com wrote:
>
>>Dear all,
>>
>>On Oracle 7.3.4 under AIX 4.1.4, we are facing database slowdown -
>>which is resolved to some extent after Oracle startup.
>>
>>What my go wrong which is resolved after startup? Same tasks are done
>>afterwards as well.
>>
>>Please help.
>>
>>
>>Regards
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Before you buy.
>
Received on Thu Dec 30 1999 - 01:09:35 CST