Database Tuning (MOSC)

MOSC Banner

Ask about Buffer Wait Statistics from statspack report

edited Apr 1, 2012 10:16PM in Database Tuning (MOSC) 5 commentsAnswered
   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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center