sumithra devi wrote:
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)
What do you mean dynamically? Is it dynamically created in your code or
are you using a persistance layer like J2EE CMP, Hibernate, JDO to
generate the SQL? If the latter, which framework are you using?
I now see that you said Weblogic. Are you using CMP EJBs ?
We created MVs to help performace with higly normalized data model.
What are MVs?
Can anyone give some tips or probe me in the right direction with more specific
questions.
Let me know the answer about how or who is generating the SQL and then I
might be able to give some specific suggestions on how to optimize.
-- Keith
Any action plan as to where to start and the direction to go of any sort will
be helpful
Thanks in advance
--
-----------------------------------------------------------------
Keith Fetterman 206-780-5670
Mariner Supply, Inc. [EMAIL PROTECTED]
http://www.go2marine.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
