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: ORACLE PAGING PERFORMANCE

Re: ORACLE PAGING PERFORMANCE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 10 Feb 2006 17:32:04 +0100
Message-ID: <asfpu1lvp3gdjdoe1ra0iqo5jrc2pubfvj@4ax.com>


On 10 Feb 2006 07:52:29 -0800, sandro.salari_at_gmail.com wrote:

>I have a quest.
>This query
>
>SELECT /*+USE_NL(nodi) */ nodi.* FROM V_MT_NODI nodi,W_MT_NRL linee
>WHERE 1=1 and linee.IL_LINEA=0 AND linee.IK_LINEA=16705 AND
>linee.IM_LINEA=1000 AND nodi.IK_NODO = linee.IK_NODO ORDER BY
>nodi.COD_ORG,nodi.SER_NODO,nodi.NUM_NODO
>
>needs 3s to extract the data.
>
>The next one
>
>( SELECT * FROM (SELECT ROWNUM AS N, a.* FROM (( SELECT
>/*+USE_NL(nodi) */ nodi.* FROM V_MT_NODI nodi,W_MT_NRL linee WHERE 1=1
> and linee.IL_LINEA=0 AND linee.IK_LINEA=16705 AND linee.IM_LINEA=1000
>AND nodi.IK_NODO = linee.IK_NODO ) ORDER BY
>nodi.COD_ORG,nodi.SER_NODO,nodi.NUM_NODO)a where rownum<=20)WHERE N>0 )
>
>needs 86s.
>
>Can anyone explain me why?
>tanx
>Sandro.

No version
No platform
No information about optimizer being used No information about statistics being current and opt_ parameter settings
No EXPLAIN PLANs being posted
No information about the brand of watch being used.

How do you expect adequate responses?

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Feb 10 2006 - 10:32:04 CST

Original text of this message

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