Re: Simple insert - 36,000 physical reads
- From: rjamya <rjamya@xxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx
- Date: Fri, 12 Dec 2008 17:30:38 -0500
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@xxxxxxxxx> 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
>
>
Other related posts:
- » Simple insert - 36,000 physical reads - Dennis Williams
- » RE: Simple insert - 36,000 physical reads - Stephens, Chris
- » RE: Simple insert - 36,000 physical reads - Ken Naim
- » RE: Simple insert - 36,000 physical reads - Michael Fontana
- » RE: Simple insert - 36,000 physical reads - Channa, Santhosh
- » Re: Simple insert - 36,000 physical reads - rjamya
- » Re: Simple insert - 36,000 physical reads - Nuno Souto
- » Re: Simple insert - 36,000 physical reads - Stefan Knecht
- » Re: Simple insert - 36,000 physical reads - Bjoern Rost