Printable View
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
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.
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