Re: db_file_multiblock_read_count parameter

Hi All,

Thanks for your responses.

I do know that we can use 'alter system' or 'alter session' to change db_file_multiblock_read_count parameter. As I mentioned in my original email, I can not use any DDL type statements in ETL tool.

I am looking for a technique or undocumented hint (if any) that we can use in SQL statement to increase the value of db_file_multiblock_read_count.

Thanks in advance for your suggestions.

Regards,
Prasad

Gregory Conron <gconron_at_hfx.andara.com> on 07/12/2000 05:47:46 PM

                                                                                
                                                                                
                                                                                


                                                              
                                                              
                                                              
 To:      ORACLE-L_at_fatcity.com, Prasada R Gunda/HLIFE         
                                                              
 cc:                                                          
                                                              
                                                              
                                                              
 Subject: Re: db_file_multiblock_read_count parameter         
                                                              

On Wed, 12 Jul 2000, Prasada R Gunda wrote:
> Hi All,
>
> We are using ETL(extraction,transformation and loading) tool to load data from
> source databases to warehouse database.
> This tool allows us to write custom sql and does not allow DDL statements.
>
> I am using full table scan on some of the tables in some sql quries. I would
> like to increase the value of db_file_multiblock_read_count when I do FTS.
>
> Is there any way I could increase the db_file_multiblock_read_count value
other
> than changing it in init.ora file.
>
> Thanks in advance for your help.
>
> Regards,
> Prasad

alter session set db_file_multiblock_read_count = <new value>;

Cheers,
GC

--
I love the way Microsoft follows standards.  In much the