hi girish,

where is the query, where is the attachment, why don't u post it as mail..


---
Good Luck..Subodh Deshpande

===============================================
Experience Is Knowledge
Wisdom Is Philosophy
==============================================







--------- Original Message ---------

DATE: Wed, 21 Apr 2004 17:24:52
From: "Girish Bhat" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed]

>
>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
>
>--------
>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] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>



____________________________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
Oracle LazyDBA home page