| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Re[2]: SPEED-UP OPERATION
Thanks for the suggestions. It hadn't occurred to me to check the
client machines. They are Pentium Pro with 256Mb memory.
Network problems have been an issue in the past, and warrant=20
more research. I believe we have completed the change to=20
switches from hubs, but I'll be asking out network administrator
a few questions!
I'll be doing some testing with the swap file size, too. I've tried=20 setting the minimum size to 500 Mb, but it didn't stick when I=20 restarted the machine. =20
It may be time to turn this one over to the IT guys.
Thanks!
>>> dgoulet_at_vicr.com 6/4/2000 >>>
Rachel,
Thanks for taking the fire out of my reply, but you left the fuel. In =
a
case like this it's best to take a whole system approach. Look at the =
network
saturation, so you have at least 10MB per second SWITCHED to the desktop? =
I
know some places still use concentrators/hubs/bridges all of which make =
things
look slow. Second, look at the desktop PC's, are they old 66MHZ machines =
or
newer. What is the memory configuration (I recommend nothing less than =
32M of
RAM) How is swap being handled, by the OS or is it hard limited. Letting =
95/NT
handle swap is one bad performance hit. Take that task away from the OS & =
hard
set the swap file size to at least three times memory. Next take a look =
at what
the end user is running on the machine. You'll get very surprised at =
what's out
there. Stock market ticker tapes, odd ball screen savers, and interactive
wallpaper just to mention a few all courtesy of the WEB. Then there are =
the
necessary, but memory and CPU intensive apps that people run as well like =
Excel,
Power Point, Adobe, etc... You may well have overloaded clients. Also =
watch
out for the "streaming audio" toys that some people like. They may not =
take up
very much memory or CPU, but they'll clobber your network bandwidth.
____________________Reply Separator____________________ Author: "Rachel Carmichael" <carmichr_at_hotmail.com> Date: 6/4/00 8:14 AM
hang on, if the SQL itself runs quickly, but it takes time to switch =
forms=20
or finish the inserts... has anyone looked at the network???
Kristen has said that the I/O, etc is running fine when run in isolation. =
So=20
the problem may be somewhere else
I am presuming that whenyou tested the SQL, you did it on the server.
Do the same test connecting to SQL*Plus from a client... if there are=20 network problems, you should see a slower response.
That;s a start anyway
>From: "Thomas L. Harleman" <tharleman_at_iquest.net>
>Reply-To: ORACLE-L_at_fatcity.com=20
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Re[2]: SPEED-UP OPERATION
>Date: Sun, 04 Jun 2000 05:56:23 -0800
>
>Some things to think about:
>Has data entry into the database always been slow?
>Were the RDBMS files distributed using Oracles Optimal Flexible=20
>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=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).
>
>--
>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
>also send the HELP command for other information (like subscribing).
--=20
Author: Rachel Carmichael
INET: carmichr_at_hotmail.com=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).
-- Author: INET: dgoulet_at_vicr.com=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 inReceived on Mon Jun 05 2000 - 17:13:12 CDT
 |
 |