Re: Slow query (only the first time)
From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com.invalid>
Date: Wed, 18 May 2011 18:38:27 +0200
Message-ID: <ir0sm5$715$1_at_dont-email.me>
El 13/05/2011 14:54, Carlos escribió/wrote:
>> Any idea of what to look next?
>
> Query Plans?
Date: Wed, 18 May 2011 18:38:27 +0200
Message-ID: <ir0sm5$715$1_at_dont-email.me>
El 13/05/2011 14:54, Carlos escribió/wrote:
>> Any idea of what to look next?
>
> Query Plans?
It's not easy to get query plans when issuing an EXPLAIN PLAN FOR query is likely to create a zombie connection :(
>>> "Oracle9i Release 9.2.0.1.0 - 64bit Production"; I heard the DBA mention..."
>
> 9.2.0.1? Get this supposed DBA fired right now.
In what real-life organisation is the DBA the person that makes decisions about funding and large-scale migrations?
-- -- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programación web: http://borrame.com -- Mi web de humor satinado: http://www.demogracia.com --Received on Wed May 18 2011 - 11:38:27 CDT