|
-
Hello grjohnson,
When file system is used, and settung a higher value for DB_FILE_MULTIBLOCK_READ_COUNT will duplicate the IO, because the OS has already read many blocks even though the request is one or 2 blocks.
More over, the wait event WAIT #1: nam='db file scattered read' can not be completely eliminated during a full table scan.
The proper test is reboot the system for every run.
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|