Something quick comes to mind: 1) What version is your Oracle? 2) Did you tune your database? 3) Do you have columns indexed properly? 4) Did you use explain plan to see if the optimizer is doing the right thing? 4) Did you use Oracle's tools to monitor the database and see what is happening while querying?
I'm not totally convinced that the sql query generated dynamically is the problem. Show us your tables and queries. -----Original Message----- From: sumithra devi [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 11:48 AM To: [email protected] Subject: [OT] Oracle Performance Issue 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
