Slow query (only the first time)

#11

On May 18, 6:38*pm, "Álvaro G. Vicario"
<alvaro.NOSPAMTH... (AT) demogracia (DOT) com.invalid> wrote:

Quote:

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:

Quote:

"> 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.

Quote:

"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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Slow query (only the first time)

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Slow query (only the first time) - 05-20-2011 , 04:00 AM