Sql tuning - Help required urgent

[urchin556]

Hi Guys,
My query is taking lot of time and i had try to reduce the time taken by it.
After all the things i have done following are the statistics

7 recursive calls
13 db block gets
3040505 consistent gets
37502 physical reads
0 redo size
48369303 bytes sent via SQL*Net to client
1914384 bytes received via SQL*Net from client
23632 SQL*Net roundtrips to/from client
0 sorts (memory)
1 sorts (disk)
354454 rows processed

Is it possible to more tune this query?? If yes,which areas should i emphasize more and is anyone there who can help me out in tuning this query.

 

[SantaMufasa]

Urchin,

My crystal ball says that you should reduce your number of physical reads and consistent gets.

Is that helpful? If not, perhaps you could post

1) your SELECT statement
2) indicate number of records in each table
3) confirm the number of rows returned
4) what columns on which tables are indexed.


Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[sem]

Regards, Dima

http://seminihin.narod.ru