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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 7.2.3 suddenly excessive cache buffer misses???

Re: Oracle 7.2.3 suddenly excessive cache buffer misses???

From: <axnn_at_hotmail.com>
Date: 1997/09/14
Message-ID: <874232797.26963@dejanews.com>#1/1

In article <3417FAF3.2F6F_at_pch.com>,
  "gmayes_at_pch.com" <gmayes_at_pch.com> wrote:

>

> Platform AIX 4.1.4 Oracle 7.2.3
> Suddenly any decent sized query thrashes the disks and drives the system
> to 100% utilization!!! and doesn't return. At the same time regular
> transtions run fine. Any Ideas???
> P.S. No changes have been made to the initialization parameters and
> database has been stable for 1.5 years

Have checked fragmentation of object..

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Sun Sep 14 1997 - 00:00:00 CDT

Original text of this message

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