The query uses a view which has a Parallel Option with degree=6.It is
Ora 9.2.04.The DB_CACHE_SIZE is 637,534,208 and the LIO is 81,070,969.
If i don't use the hint in the query ,it takes more than 6 hrs and
hangs up.After using the hint i can execute the query within 1.05 hrs.
Also after i use the INDEX hint in the parallel query,the execution
time is reduced to 10%.
Please help me tune it further if possible.



> In my mind, the only way to reduce the LIO is to rewrite the query.
> You are doing LIO because you need to do them.
>
> Otherwise you can look whether when you need to access the whole
table, you
> are using an index (you shouldn't)
> Or you have an index that should be used and instead of using this
index
> you are doing a full table scan...
>
> Hope this helps,
>
> Laly.
>
>
>
>
> Extranet
> [Email Address Removed] - 21/04/2004 19:01
>
> Pour : oracledba
>
> cc :
>
>
> Objet : Query Tuning
>
>
> Hi List,
> I have a query which is taking around 1.05 hrs to execute and doing
a
> lots of Logical I/O's.Can anyone tell me how to reduce the LIO's.
>
> Thanks,
> Girish
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-
[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these terms:
> http://www.lazydba.com/legal.html
>
>
>
>
>
>
>
>
> This message and any attachments (the "message") is
> intended solely for the addressees and is confidential.
> If you receive this message in error, please delete it and
> immediately notify the sender. Any use not in accord with
> its purpose, any dissemination or disclosure, either whole
> or partial, is prohibited except formal approval. The internet
> can not guarantee the integrity of this message.
> BNP PARIBAS (and its subsidiaries) shall (will) not
> therefore be liable for the message if modified.
>
> ---------------------------------------------
>
> Ce message et toutes les pieces jointes (ci-apres le
> "message") sont etablis a l'intention exclusive de ses
> destinataires et sont confidentiels. Si vous recevez ce
> message par erreur, merci de le detruire et d'en avertir
> immediatement l'expediteur. Toute utilisation de ce
> message non conforme a sa destination, toute diffusion
> ou toute publication, totale ou partielle, est interdite, sauf
> autorisation expresse. L'internet ne permettant pas
> d'assurer l'integrite de ce message, BNP PARIBAS (et ses
> filiales) decline(nt) toute responsabilite au titre de ce
> message, dans l'hypothese ou il aurait ete modifie.
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-
[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page