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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hit Ratio fallen through the floor at 31% since a db crash ye

RE: Hit Ratio fallen through the floor at 31% since a db crash ye

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 08 Feb 2001 13:47:18 -0800
Message-ID: <F001.002AFB0F.20010208134057@fatcity.com>

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: MGogala_at_oxhp.com

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).
Received on Thu Feb 08 2001 - 15:47:18 CST

Original text of this message

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