Re: 2.5 billion row table scan...

From: <michael_bialik_at_my-deja.com>
Date: 2000/06/05
Message-ID: <8hh0ss$i5e$1@nnrp1.deja.com>#1/1

Hi.

What is the value of DB_FILE_MULTIBLOCK_READ_COUNT parameter in INIT.ORA file ?
Try to increase it ( it's OS dependent value ) to 32 ( check documentation ).

What db_block_size you are using? Is it possible to re-create DB with greater block size?

HTH. Michael.

In article <8hgv5a$gla$1_at_nnrp1.deja.com>, sergey_s_at_my-deja.com wrote:
>
>
> Due to time constraints, we may have to stick with scanning 2.5
billion
> row table (and figure out another access path later). It's partitioned
> (each partition about 50-60 mil rows). Current memory is at 4 Gig, and
> there are six processors (Sun machine). We will probably double the
> memory soon and add two more processors.
>
> With it's current configuration, however, it was still cheaper to scan
> the table than use any indexes, and it takes roughly 18 hours.
>
> Can you suggest anything to speed up the scan?
>
> Thank you!
>
> Sergey
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 05 2000 - 00:00:00 CDT