Just how many tables are you joining in these tables here? When I
see phrases like "highly normalized data model", my "danger will robinson"
alarm goes off. If you overnormalize, your database is going to kill itself
joining tables for you. Sometimes you just have to denormalize to make
performance workable.
Yah, I know, I know, somewhere out there a DBA is screaming at his
email client right now, but that's why he's a DBA and we write apps :).
Seriously, get some of your typical queries, run them through sqlplus with
show plan on and take a look at what's going on.
--- Pat
> -----Original Message-----
> From: Jonnalagadda, Sumithra [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 09, 2006 1:07 PM
> To: 'Tapestry users'
> Subject: RE: [OT] Oracle Performance Issue
>
> 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: tapestry-user@jakarta.apache.org
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
