Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: i need opinions or suggestions to a problem!

Re: i need opinions or suggestions to a problem!

From: Thomas Schwickert <schwickert_at_yahoo.com>
Date: Tue, 25 Sep 2001 10:20:11 +0000 (UTC)
Message-ID: <7d0f3a1b2193c2929860e2ec8ac68919.20305@mygate.mailgate.org>


"a.okpala" <a.okpala_at_deutschepost.de> wrote in message news:9opksn$hge4_at_ppd00021.deutschepost.de...

> Hi,
>
> i have two identical users. Both have been given identical statements 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

check explain plans
and then look further ...

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Sep 25 2001 - 05:20:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US