Are the two statements issued against the same platform and from comparable
clients?
Also it would be worth tracing the two sessions to see exactly what sql is
actually being run.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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
>
>
Received on Tue Sep 25 2001 - 06:34:09 CDT
