Re: Performance difference issue between two users of the same database

On 28 May 2005 01:53:48 -0700, Talk2Vineet_at_gmail.com wrote:

>Yes, Both the user have the same privileges, moreover the second user
>is the just a clone of the first user and having same roles grants and
>prevs as first one has. My concern is not why the execution plan is
>different for the same query, but the response time that has a diffence
>almost 3 times between the two users. So please help me
>out...............

I think the only way you can get sound advice, is when you stop posting all these vague stories, leaving too much to guess.

What you would need to post is actual trace files, including explain plans.

--
Sybrand Bakker, Senior Oracle DBA