| rahul |
Posted: Aug 31, 2007 07:05:05 AM |
Total Post: 16
Joined: Feb, 2007
|
Dear Friends
i have a question if any one know that then please give me answer
Q;- In Statspack Report - DB FILE SCATTERED READ Event .
what the meaning DB FILE SCATTERED READ ?
thanks
amit kumar bhatnagar
|
|
|
 Mohammed Taj |
| Posted: Sep 01, 2007 01:13:09 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
it means sql query looking/read more than one block at a time.
if it is showing in top 5 wait event then increase buffer cache or set db_file_multiblock_read_count parameter
Regards
Taj
|
|
|
|
|
| Dubey |
| Posted: Oct 22, 2007 07:01:16 AM | |
|
Total Post: 2
Joined: Oct, 2007
|
DB file scattered event means query goes for a full table scan so either u can make an index so that index is use by query or if requirement is as such that u required full table scan then increase DB_FILE_MULTIBLOCK_READ_COUNT .
|
|
|
|
|
| mani |
| Posted: Jan 16, 2008 04:24:40 AM | |
|
Total Post: 6
Joined: Jan, 2008
|
you have to set index (i.e)it goes in full table scans.
if index is set already, you can force the index thro hints - /*+index(emp emp_idx)*/
emp - table name
emp_idx - index name
or you can set the parameter in init.ora -
optimizer_index_cost_adj=<value>
you can give values ranges from 1 to 100
This parameter alters the costing algorithm for access paths involving indexes. The smaller the value, the lower the cost of index access.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
