Database Tuning (MOSC)

MOSC Banner

AWR - Segments by Row Lock Waits

edited Nov 4, 2009 5:11AM in Database Tuning (MOSC) 6 commentsAnswered
  I am reviewing AWR report and found that in the following sections, the majority of objects are indexes, and indexes'  ini_trans set to 2. Is there a correlation between these objects shows up in AWR-waits and ini trans more than 1? Am in process of reorganizing these objects and need your opinion?

AWR sections:
Segments by Physical Reads, Segments by Row Lock Waits,Segments by ITL Waits and Segments by Buffer Busy Waits

Thanks.

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