Re: Improving performance of full table scans

From: <sjaffarhussain_at_gmail.com>
Date: 12 Sep 2006 02:55:15 -0700
Message-ID: <1158054915.804822.155630@m73g2000cwd.googlegroups.com>

One parameter that mostly affect for choosing FTS is db_file_multiblock_read_count.
Since, its a warehouse db, I wonder, you need a big value for this parameter.

anish wrote:
> Hi all,
>
> Can anyone help me in the ways for imporving the performance of full
> table scans without additional hardware.
>
> Anish
Received on Tue Sep 12 2006 - 04:55:15 CDT

This message: [ Message body ]
Next message: Ralf Bender: "Q: Using of variables in PL/SQL in a LOOP??"
Previous message: sjaffarhussain_at_gmail.com: "Re: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small"
In reply to: anish: "Improving performance of full table scans"
Next in thread: David Aldridge: "Re: Improving performance of full table scans"
Reply: David Aldridge: "Re: Improving performance of full table scans"

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

Original text of this message

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