Ask about Buffer Wait Statistics from statspack report
Hi all,
I ask about the Buffer Wait Statistics section from report was generated from statspack.
From the Oracle tuning white paper, this section relate with File and Tablespace IO section. I can use some scripts to determine which segment, files are contended for. And I think to solve problem is move datafiles related to another good disks, am I right ? And any other methods to solve it ?
Some buffer types waited for include: free list, data block, index block, undo block, undo header, ... And at here, if buffer type waited is freelist blocks and Oracle said that increase the number of freelists in the segment. How I can do this ?
0