Re: Slow query (only the first time)
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Fri, 20 May 2011 02:00:19 -0700 (PDT)
Message-ID: <d5866797-883c-453b-bb65-edd00dd3ebec_at_c26g2000vbq.googlegroups.com>
On May 18, 6:38 pm, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com.invalid> wrote:
> 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
> --
Date: Fri, 20 May 2011 02:00:19 -0700 (PDT)
Message-ID: <d5866797-883c-453b-bb65-edd00dd3ebec_at_c26g2000vbq.googlegroups.com>
On May 18, 6:38 pm, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com.invalid> wrote:
> 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
> --
Álvaro:
>>"> It's not easy to get query plans when issuing an EXPLAIN PLAN FOR query
> is likely to create a zombie connection :("
I have no idea about what you mean... Anyway: query plans are the first place where I'd look at.
>>"In what real-life organisation is the DBA the person that makes decisions about funding and large-scale migrations? "
It's not about 'large-scale migrations', it is about UPGRADING to newer versions and aplying patches (9.2.0.8 is the last 9i version that I can remember), which is one of the main tasks that a proper DBA must take care of.
Saludos.
Carlos. Received on Fri May 20 2011 - 04:00:19 CDT