Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance difference issue between two users of the same database
<Talk2Vineet_at_gmail.com> wrote in message
news:1116911759.883646.259340_at_g43g2000cwa.googlegroups.com...
> Hi All,
>
> I have a problem, would appriciate you if your help makes me resolve
> this issue. I have created two users in the same database and when i
> run a query in these two users, one user executes it in a minute, while
> other takes more than 10 minutes. Query to be run has mixture of views
> and tables while views in turn has many tables joined with each other.
> I have checked all the indexes and both the users have similiar
> indexes, when checked default tablespaces, the fast user's is system
> while other's is users. According to Expain plan of the query, the user
> which is fast using an index on a table while other is not. I got stuck
> in it for the last 2 weeks but could not make it work, even i created
> many users and even in different schemas also but it didn't work.
> Please help me out.
>
Hi,
Are the system privileges of both users the same ? Maybe one user has QUERY
REWRITE privilege and the other one not ? This could explain the different
execution plans.
Matthias Received on Thu May 26 2005 - 17:34:05 CDT