Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: SPEED-UP OPERATION
Some things to think about:
Has data entry into the database always been slow?
Were the RDBMS files distributed using Oracles Optimal Flexible Architecture
(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
317-334-1317 Office
317-334-1301 Fax
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Kristen
Cameron
Sent: Friday, June 02, 2000 5:56 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: SPEED-UP OPERATION
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.
-- Author: Kristen Cameron INET: cameronkgd_at_inac.gc.ca 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 mayReceived on Sun Jun 04 2000 - 07:28:13 CDT
![]() |
![]() |