| datafile I/O problem [message #56313] |
Tue, 18 March 2003 14:37  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
hello all,
i have an important problem going on....
After realizing that a simple delete statement takes minutes to come back on our production environment, I have found out the following event in v$session_wait during the statement execution: db file scattered read
It turns out it takes minutes and minutes to write one row to a data file, almost all data files take quite a bit of time.
What can be the problem, how do I troubleshoot this, we have a SAN storage, can that be a problem? Please advise.
|
|
|
|
| Re: datafile I/O problem [message #56335 is a reply to message #56313] |
Wed, 19 March 2003 20:36  |
Kishor Bhalwankar
Messages: 33
Registered: February 2003
|
Member |
|
|
Hi
please increate DB_FILE_MULTIBLOCK_READ_COUNT to 16 or 32 or avoid full table scans or INDEX_FFS
it will decrease u r scattered read.. it generally due to full table scans into buffer cache.
I think its sufficient
any queries please welcome
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
