investigate.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
> Of Larry Meadors
> Sent: Friday, February 10, 2006 1:03 PM
> To: Struts Users Mailing List
> Subject: Re: [OT off topic] Oracle Database Performace Issue
>
>
> Huh..
ect: Re: [OT off topic] Oracle Database Performace Issue
Huh...and that runs slow?
Imagine that.
;-)
Sweet mother of mystery, that is one gnarly query. Seems to have a lot
of repetition in it...could it be redone as a stored procedure?
Are you running it as a prepared statement?
Larry
On 2/10/
Have you run an explain plan?
Jonnalagadda, Sumithra wrote:
Here is the query
SELECT PTI.PARTY_ID AS "CUSTID",
PTI.CMA_CUSTOMER_NUMBER AS "CUSTNUM",
PTI.SOURCE_ID AS "CUSTSOURCE",
PTI.PARTY_CLASS_CD AS "CLASS",
(SELECT CMAPSV.STATUS_VALUE
FROM type3 CMAPS,
type4 CMAPSV
WHERE PTI.PARTY_TYPE_IN
Jonnalagadda, Sumithra wrote:
Here is the query
SELECT PTI.PARTY_ID AS "CUSTID",
PTI.CMA_CUSTOMER_NUMBER AS "CUSTNUM",
PTI.SOURCE_ID AS "CUSTSOURCE",
PTI.PARTY_CLASS_CD AS "CLASS",
(SELECT CMAPSV.STATUS_VALUE
FROM type3 CMAPS,
type4 CMAPSV
WHERE PTI.PARTY_TYPE_INSTANCE_ID = CMAPS.PARTY_TYPE_IN
Users Mailing List
Subject: Re: [OT off topic] Oracle Database Performace Issue
Huh...and that runs slow?
Imagine that.
;-)
Sweet mother of mystery, that is one gnarly query. Seems to have a lot
of repetition in it...could it be redone as a stored procedure?
Are you running it as a prepared
Huh...and that runs slow?
Imagine that.
;-)
Sweet mother of mystery, that is one gnarly query. Seems to have a lot
of repetition in it...could it be redone as a stored procedure?
Are you running it as a prepared statement?
Larry
On 2/10/06, Jonnalagadda, Sumithra <[EMAIL PROTECTED]> wrote:
>
Here is the query
SELECT PTI.PARTY_ID AS "CUSTID",
PTI.CMA_CUSTOMER_NUMBER AS "CUSTNUM",
PTI.SOURCE_ID AS "CUSTSOURCE",
PTI.PARTY_CLASS_CD AS "CLASS",
(SELECT CMAPSV.STATUS_VALUE
FROM type3 CMAPS,
type4 CMAPSV
WHERE PTI.PARTY_TYPE_INSTANCE_ID = CMAPS.PARTY_TYPE_INSTANCE_ID
AND CMAPS.PARTY_STATUS
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
sumithra devi asked:
> We have sql query that is generated dynamically(this is what
> is causing teh problem)
I'm no expert in tuning database access, but even for a one-time use,
Oracle can do a better job if you use a PreparedStatement rather than a
Statement. Of course, if you can re-use that
All your database are belong to us. ;)
Have you run an explain plan for your poorly performing query?
-Dennis
sumithra devi <[EMAIL PROTECTED]>
02/09/2006 01:42 PM
Please respond to
"Struts Users Mailing List"
To
user@struts.apache.org
cc
Subject
[OT off topic] Oracle Database Performa
10 matches
Mail list logo
