Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: I need opinions or suggestions
"a.okpala" <a.okpala_at_deutschepost.de> wrote in message news:<9opkj9$hge3_at_ppd00021.deutschepost.de>...
> Hi,
>
> i have two identical users. Both have been given identical statement to
> execute. One user executes the statement within a tenth of a second, while
> the other user needs more than four hours to execute the same statement. I
> have cross-checked that the both have the same grants as well as role.
> Does anybody have a suggestion as how this problem might be corrected?
>
> Thanks!
> A.O
AO, what version of the database are you on?
1- If 8.1 and row level security is in use that can create problems like this though it would be unusual as the problems RLS normally creates are like the user cannot see the row they just inserted when they query, two users in same department get different results for same query etc....
2- Are the two users seeing the same underlying objects? Are they both querying the same owner.table_name for all tables or are they going after their own, or someone else's, version of some of the objects? Check the public and private synonyums as well as user owned objects.
If the users are using their own tables then you have missing indexes, bad statistics, or sheer quanity of data that could be the cause.
I hope this helps.