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

Report message to a moderator

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: 8458
Registered: January 2010
Location: Global Village
Senior Member
If you post th coplete reports (before and after your changes) perhaps someone can advise.

Report message to a moderator

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: 1576
Registered: May 2010
Location: UK
Senior Member
You'll probably need to give some detail around the application behavior too.

Report message to a moderator

Previous Topic: DB Restart after Table Partition
Next Topic: Cost on imported stats from production is changed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 24 20:11:04 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.