We are using oracle 9i. We are cerating stats. CPU usage is hitting max when the users are 5-6
-----Original Message----- From: Steve Shucker [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 1:08 PM To: 'Tapestry users' Subject: RE: [OT] Oracle Performance Issue I'll add two things to the list: 1) If you're generating your own queries, parameterize them. It'll save oracle from a lot of CPU-intensive parsing 2) Analyze everything in your schema if you haven't already done it. 10g does some of this automatically, but doesn't always keep them current. 9i you can see immense benefits from creating stats. -Steve -----Original Message----- From: Ed Yu [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 12:00 PM To: 'Tapestry users' Subject: RE: [OT] Oracle Performance Issue 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
