i am using oracle 9i with windows 2000 server
nearly 50 users are using this server

I am having table "Pp_Receive_Detail_Trn" contain 8 lakhs records

if i am executing this qury

select SUM(Pp_Receive_Detail_Trn.Received_Pieces),
Pp_Receive_Detail_Trn.Process_Fk,Pp_Receive_Detail_Trn.Factory_Tbl_Fk
from Pp_Receive_Detail_Trn
where
to_date(Pp_Receive_Detail_Trn.Prod_Rec_Date,'DD/MON/YY') >= '01/MAR/06' AND
to_date(Pp_Receive_Detail_Trn.Prod_Rec_Date,'DD/MON/YY') <= '11/MAR/06'
group by Pp_Receive_Detail_Trn.Process_Fk,Pp_Receive_Detail_Trn.Factory_Tbl_Fk

it is taking nearly 10 secs

this is very slow for our process...

all the fields i have indexed

pls give solution for this
for coming result with speed

If any database parameters i have to check pls tell me ???