Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE PAGING PERFORMANCE
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 DBAReceived on Fri Feb 10 2006 - 10:32:04 CST