Re: powerbuilder in rbo and multiple constraint question...

Powerbuilder is a GUI. just like forms. This is what typically happens with 3rd party apps. They develop them some time in the past. Oracle adds new features, they dont want to spend the money to test to see if it works. So they tell customers not to use them. Its how they keep costs down. New development costs money. Most people buy these 3rd party applications because its cheaper than making their own. Making changes to them would cause them to have to raise prices.

Which 3rd party application is that? I dont like that they lied. It would be better if they were just honest about. Becareful just analyzing the tables and letting the CBO take over. Old RBO applications can be loaded with hints that can cause problems in the CBO.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 15, 2004 9:54 AM

> I'm working with a 3rd party vendor to resolve some performance issues
with
> there call center app. The app is written in PowerBuilder. When I traced
> the offending sessions, I noticed the queries are being run under the rbo.
> When I run those same queries under the cbo the response time is
> dramatically different. I asked why they insisted on running under the
rbo.
> There response was that it's a limitation of powerbuilder. I don't buy
that
> for a second. ...anyone know for sure?
>
> ..and on a side note...my company is developing a call center app in .not.
> The dba's were conveniently left out of the design process. I just took a
> look at the schema they are using and noticed redundant constraints on
> almost every table. i.e. not null, primary key, unique on the same column.
> Before I investigate myself with a 10046, does anyone know if oracle has
to
> do multiple recursive sql to validate each constraint or is it smart
enough
> to know they are redundant and only validate the pk constraint?
> .........when I saw this, I blasted the developers (admittedly some
> misdirected aggression) for not having a clue what they were working with
> and blankly stated that the redundant constraints (among other things if
> found...no bind variables for one) would negatively affect performance.
> ..after possibly putting my foot in my mouth I'm looking to validate what
I
> said. ...if I don't get any responses to this, I'll run the trace myself
> and post my findings. ....oh yeah...the .not developers responded by
saying
> the redundant constraints wouldn't be a problem in sql server.
..something
> I'm almost positive they haven't validated either.
>
> Thanks!
> chris
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chris Stephens
> INET: ChrisStephens_at_affina.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  INET: ryan.gaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).