Re: Insert slow on 817 compared to 815

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 13 Feb 2002 19:09:25 +0100
Message-ID: <gtal6uglt85j2bhri5qbfjlmtdndm2uhk7@4ax.com>

On 13 Feb 2002 06:59:17 -0800, dwms_at_space.com (Dan Williams) wrote:

>Experiencing a problem where the same application (compiled against
>817) performs much faster running against 815 than against 817. . .
>Both databases are running on the same server. Both have roughly the
>same amount of data. And, both have the same ddl (indexes, triggers,
>etc). Has anyone experienced a similar problem? I've read the
>README's provided with 817, but nothing seems to give me a clue as to
>what I might need to change.

And before the upgrade there was only 1 database on that server? Probably your server is too light to allow for 2 instances.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 13 2002 - 12:09:25 CST