Ours is a J2ee application with weblogic and Oracle database. we are finding performance issues and when analysed saw that cpu usage on oracle databse side is very high.
At a high level this is what we have: We have sql query that is generated dynamically(this is what is causing teh problem) We created MVs to help performace with higly normalized data model. Can anyone give some tips or probe me in the right direction with more specific questions. Any action plan as to where to start and the direction to go of any sort will be helpful Thanks in advance
