Re: performance problem

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 19 Sep 2000 08:41:46 GMT
Message-ID: <8q78sa$t2f$2@crax.cesnet.cz>

: User has a query that runs in 7 minutes. When I run the same query on
: the same machine on the same database it runs more than 5 hours.

Are you sure you are running query against the same db object as your user do ? I have similiar problem and solution was simple. User has synonym for some table but with significantly less rows than my table.

Check explain plan for user query connected as user and your query.

Or test some session settings user can alter. optimizer_goal...

I hope it helps

Starous Received on Tue Sep 19 2000 - 03:41:46 CDT