Re: Simple insert - 36,000 physical reads

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 12 Dec 2008 17:30:38 -0500
Message-ID: <9177895d0812121430u63f48f4eldda2453e1a7275c3@mail.gmail.com>

Lots of indexes on the tables could also cause additional pio attributed to main query. possible fk validations ?

Raj

On Fri, Dec 12, 2008 at 3:55 PM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:

> List,
>
> Oracle 10.2.0.4, Solaris 8
>
> I've found a simple insert that has:
> 1 execution
> 2,512,102 Buffer Gets
> 36,479 Physical Reads
> 1 Parse call
> 1 Row
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 12 2008 - 16:30:38 CST

This message: [ Message body ]
Next message: Wolfgang Breitling: "RE: 10g slowdown"
Previous message: Wang, Tao: "perl DBD::Oracle and external password store"
In reply to: Dennis Williams: "Simple insert - 36,000 physical reads"
Next in thread: Nuno Souto: "Re: Simple insert - 36,000 physical reads"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message