hi

could you show me your query or without taht since you would be peforming a full table scan try with this in case your database is not a 24X7

set the following initsora parameter
db_file_multiblock_read_count integer 64 id.
so taht you can get the results faster.

hope this helps

regards\
hrishy