Barb, pick the slowest application and examine it for the waits. What is the
application waiting for?
Take a look at v$session_event (cumulative) and v$session_wait (current
wait). If you see things
like "scattered db file read' or 'sequential db file read', then you have a
problem with access path
(optimizer). If that is the case, you'll need to pull a few tricks with the
optimizer. The best thing that can
be done with the optimizer on 8.1.5 is the upgrade to 8.1.7. If you have
'enqueue wait', examine your ITL,
(initrans/maxtrans) and lock related parameters. If you have "log space
waits", increase your log buffer.
If you have "free buffer waits", increase your buffer cache. Next, examine
your alert log and examine
the frequency of checkpoints. If that is more then once every 10 minutes or
so, increase your logfiles
in size & numbers. Size does matter! When this is done, examine your
v$librarycache and v$rowcache,
pin the frequently used procedures and adjust the size of your shared pool.
Next, consider using MTS
and defining the large pool to separate your sorts and hash actions from
your PL/SQL objects. After that,
examine your tables and see how are they used. Put the big reference tables
in hash clusters, the small ones
in the "KEEP" buffer pool and put the transaction and the history tables in
the "RECYCLE" buffer pool.
consider using the partitioning option for your largest tables and consider
moving all your objects to
locally managed tablespaces. do not forget to spread your IO across several
controllers.
With a little luck, you will be done just in time to perform the next major
upgrade, when the process will
start all over again.
Enjoy!
-----Original Message-----
Sent: Thursday, February 08, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
I tried that one already!!
-----Original Message-----
Sent: Thursday, February 08, 2001 12:19 PM
To: Multiple recipients of list ORACLE-L
Here we like to blame the network on all problems, irregardless of what it
is (mostly to bug the network guy).
-----Original Message-----
Sent: Thursday, February 08, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
We are running 8.1.5 on Solaris.
We can't seem to find the cause - everything is up and running fine, just
extremely slow.
What should we be looking at?
TIA,
Barb
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
