R
Rob Fitzpatrick
Guest
The BI file can be a bottleneck if not tuned for your workload, and especially if they're at the defaults. What are your settings for: - BI block size - BI cluster size -bibufs BI empty buffer waits/sec, shown in promon R&D 2 5 Also: - AI block size -aibufs You haven't mentioned yet whether you're running page writers; that's important. Are you running OE Replication? If so, the target's configuration may also affect you. "resource Monitor is showing the most active disk I/O write session is prowin32.exe to 3 extents of the database. 1 is the index extent and the other is a data extent." What is the third?
Continue reading...
Continue reading...