Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Lousy performace

Re: Lousy performace

From: Tapio Luukkanen <vtl_at_hemuli.tte.vtt.fi>
Date: 1997/05/01
Message-ID: <wayb9zo6e1.fsf@morko.tte.vtt.fi>#1/1

Paul <pnutts_at_writeme.com> writes:
> Forms take a long time to open and the wait for information during the
> order entry process is a show-stopper. I realize that this is not very
> specific information (it is about all I know without asking someone),
> but our old AS400 at 9600 BAUD (character based) runs rings around our
> new system.

Three years ago we had a similar problem with opening forms (Forms 3.0). And the performance even deterioated as new users we added to the system.

The reasons for this were:

We traced (tkprof'd) the problem to the fact, that when the form starts, it checks from some internal tables what kind of access rights the user has to the form's base tables and other elements. As I recall, the access plan for public synonyms included some "heavy" full table scanning.

Our workaround was to explicitly name the schema (ie. table) owner in the forms, ie. instead of using "TABLE = foo" we substituted "TABLE = owner.foo". This removed the full table scans, and the perfomance became ok.

And sorry, I don't know how this is done in Forms 4; this was in the good old days of direct .inp -file editing.

> Is it really our network or are we overlooking something? Any help would
> be appreciated and you will become our hero.

If the synonyms-thing is your the problem, it might be tested easiest by adding the table owner to some form which has many base tables.

Alternatively, you might try to turn column security off. My memory is hasty about this thing, though.

Anyway, hope this helps...

 Tapio L.

-- 
! tapio.luukkanen_at_vtt.fi 
Received on Thu May 01 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US