Hi,
Can anybody suggest me for this problem
Here we have Oracle 8i on Windows NT set up.

I run the following Query to check how many number of times full table scan is taking place
and got the following result

select name,value from v$sysstat where name='table scans(long tables)';

name value
table scans(long tables) 24519

The value for the Parameter DB_FILE_MULTIBLOCK_READ_COUNT is 16

My question is should I increase this value for the better performance.How much should I increase?What is the maximum limit for this parameter in Windows NT environment.

Regards,
Saurabh