Prasada,
It is a dynamic parameter that can be modified using an "alter
system" or an "alter session" as the case may be.
Cheers,
Gaja.
- Prasada R Gunda <Prasada.Gunda1_at_hartfordlife.com> 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
>
>
> --
> Author: Prasada R Gunda
> INET: Prasada.Gunda1_at_hartfordlife.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
> You may
> also send the HELP command for other information (like
subscribing).
Gaja Krishna Vaidyanatha
Director, I-O Management Products
Quest Software Inc.
(972)-304-1170
gajav_at_yahoo.com
"Opinions and views expressed are my own and not of Quest"
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
Received on Wed Jul 12 2000 - 17:22:33 CDT
