Re: performance problems

From: Ralf Zwanziger <goldensurfer_at_gmx.de>
Date: Wed, 02 Jul 2003 08:22:33 +0200
Message-ID: <41u4gv443c6mnp2144k6rq02r85a37g14o@4ax.com>

On Mon, 30 Jun 2003 18:26:09 +0200, "Georg Walk" <Georg.Walk_at_cai.de> wrote:

>We have performance problems with a complex system. We use a compaq proliant

Hi,
three ideas that might help to find, where the problem is:

If you have shared server, try to connect dedicated. This can easily be done by modifying the tnsnames.ora just by adding (SID=DEDICATED) in the CONNECT_DATA-paragraph in tnsnames.ora We had performance problems occasionally with shared server which could be solved by switching to dedicated server on 8i
Have a look at tables with only a few rows of data. Are they defined parallel? If so, try: ALTER TABLE <TableName> NOPARALLEL on these tables.
When the performance problem occurs again, start enterprise manager and have a look on the database locks. Are there many tables / rows locked?

Well, I don't know if these ideas help, but we had performance problems in the past and these three reasons are the ones I remembered.

Hope that helps.
Bye,
Ralf Received on Wed Jul 02 2003 - 01:22:33 CDT