Home » RDBMS Server » Server Administration » ITL wait events for indexes (11g, 11.2.0.3, solaris10)
ITL wait events for indexes [message #636445] Fri, 24 April 2015 01:49 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

We were observing the ITL wait events for indexes at AWR reports. To overcome from this problem, we had increased init trans for indexes to 60.
Again same issue arose, we had changed it to 100. Even now, same indexes are appearing on AWR's ITL wait section.

Please suggest on this...

Regards,
Ashish Kumar Mahanta
Re: ITL wait events for indexes [message #636447 is a reply to message #636445] Fri, 24 April 2015 01:59 Go to previous messageGo to next message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
If you post th coplete reports (before and after your changes) perhaps someone can advise.
Re: ITL wait events for indexes [message #636448 is a reply to message #636447] Fri, 24 April 2015 02:12 Go to previous message
Roachcoach
Messages: 1571
Registered: May 2010
Location: UK
Senior Member
You'll probably need to give some detail around the application behavior too.
Previous Topic: DB Restart after Table Partition
Next Topic: Cost on imported stats from production is changed
Goto Forum:
  


Current Time: Sun Oct 21 18:44:20 CDT 2018