RE: Re[2]: SPEED-UP OPERATION

Thanks for the suggestions - you've given me a few new leads to follow.

The answers to your questions are:
No - but it has been since the new forms were added No - we've got one CPU and Raid 5, unfortunately Don't think so - but I'll be checking
Not sure - but I'll know soon!

Much appreciated.

>>> tharleman_at_iquest.net 6/4/2000 >>>

Some things to think about:
Has data entry into the database always been slow? Were the RDBMS files distributed using Oracles Optimal Flexible Architectur= e
(OFA)?
Do you have too many, unnecessary indexes on your tables? Have you indexed all foreign keys?

Tom Harleman
11080 Willowmere Dr.
Indianapolis, IN 46280
317-844-2884 Home
317-843-9122 Home Office

ThinkFast CONSULTING, Inc. (formerly Pinnacle Solutions) Technical Consultant
3500 DePauw Blvd. Suite 2071
Indianapolis, IN 46268
tharleman_at_thinkfast.com=20
317-334-1317 Office
317-334-1301 Fax

-----Original Message-----
Cameron
Sent: Friday, June 02, 2000 5:56 PM
To: Multiple recipients of list ORACLE-L

The problem with finding the bottleneck is that the users are not using the application because it is so slow. The database is a reference library of sorts. Even when in use, only three or four users at a time may be adding entries. I'm not sure of the number of users querying the database, but it would only be a few a day generally.

For the moment, the users are recording the information on paper for later entry into the database.

So, how the heck do I figure out what is wrong?

I asked the users to do some work in the application for a few hours a couple of weeks ago and found absolutely no problems with IO, cpu, or anything else I could think of to check. I used bstat/estat and a variety of performance tuning scripts. It can take minutes (3 to 10) for an insert or update via the application, and even switching between forms takes 30-60 seconds, but the SQL involved runs in hundredths of a second when run on its own.

Sigh. I think I'm going to have to learn Oracle Forms next so that I can figure out what is going on.

>>> stephane_paquette_at_yahoo.com 6/2/2000 >>>
Have you identified a specific bottleneck ? Is it IO or cpu ?
How do you checked the SQL ? Personnaly I used tkprof.

• Kristen Cameron <cameronkgd_at_inac.gc.ca> a =E9crit :
  > I'm trying to speed up an application built using
  > Forms 4.5. I have extracted
  > all the SQL executed by the application (30+
  > statements) and am checking
  > them, but see no problems thus far. I have already
  > checked the usual suspects
  > (hit ratios, swapping and paging, etc.) and have
  > discovered that the
  > database itself runs beautifully!
  >
  > Is it possible that the coding within the Form
  > itself causes it to run slowly?
  > I don't mean the SQL code, but the code that Forms
  > uses. There are
  > triggers etc. built into the forms that do not
  > access the database.
  >
  > Any comments or suggestions?
  >
  

--
Author: Kristen Cameron
  INET: cameronkgd_at_inac.gc.ca=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

--=20
Author: Thomas L. Harleman
  INET: tharleman_at_iquest.net=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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