oracle speed(i want actual commands)

[pintesh]

pls tell me something about how to increase speed ,i.e. for retrieving records from oracle database i.e back end .
because for me it is taking 30-40 minutes for counting 3million
records. and i will be having some billion records database.
thanx pintesh

[vishywish]

Are u trying to count from a single table or it is a join of more than two tables?
You will have to tune your query according to that.
Simultaneouly ou can check Db_block_buffer size of the Init.ora parameter file.
You can check for optimum shared_pool_size in the SGA.
Check it out and then reply if it helps.

[hrishy]

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