Oracle mechanics

Igor Usoltsev's Oracle blog

  • Categories

  • Advertisements

Posts Tagged ‘execution plan’

Huge sql plans comparision

Posted by Игорь Усольцев on January 27, 2014

original in Russian

Once upon a day we’ve got a little trouble on OEBS (Oracle Apps)  db server:

– while there not exist any valuable I/O related waits, these temporary  difficulties were not catastrophic, and db servers still remain accessible and manageable. But high CPU load / LA reason are typical for Oracle performance problem, and this is interesting topic for the post imho

AWR for the problem period: Read the rest of this entry »


Posted in 11g, CBO, Oracle | Tagged: | Leave a Comment »