RE: db_file_multiblock_read

From: Prasada R Gunda <Prasada.Gunda1_at_hartfordlife.com>
Date: Thu, 13 Jul 2000 09:00:24 -0400
Message-Id: <10557.111940@fatcity.com>

--0__=ebZRur8D3QMEAVvTRyijSyrjXxBBCZXJE3XwozUgx3Sb1YJDidTOvUUO Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Alex,
I agree and I am aware that there is no use to increase this parameter such a way that db_block_size*db_file_multiblock_read_count is more than system I/O size. I would like to increase this parameter with in that limit only.

Regards,
Prasad

Alex Hillman <alex_hillman_at_physia.com> on 07/12/2000 09:19:29 PM

Please respond to ORACLE-L_at_fatcity.com

                                                                                
                                                                                
                                                                                


                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: Prasada R Gunda/HLIFE)                        
                                                              
                                                              
                                                              
 Subject: RE: db_file_multiblock_read_count parameter

There is no sense to make this parameter more then max IO size for OS. For solaris before 2.7 it is 64K, after that it is configurable in /etc/system. Do not remember what is maximum, but not less then 128K.

Alex Hillman

-----Original Message-----
Sent: Wednesday, July 12, 2000 7:36 PM
To: Multiple recipients of list ORACLE-L

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! http://mail.yahoo.com/

--
Author: Gaja Krishna Vaidyanatha
  INET: gajav_at_yahoo.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).


--0__=ebZRur8D3QMEAVvTRyijSyrjXxBBCZXJE3XwozUgx3Sb1YJDidTOvUUO
Content-type: text/html; 
	name="att1.htm"
Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+
DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o
dG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgTkFNRT0iR2VuZXJhdG9yIiBDT05URU5U
PSJNUyBFeGNoYW5nZSBTZXJ2ZXIgdmVyc2lvbiA1LjUuMjQ0OC4wIj4NCjxUSVRMRT5SRTogZGJf
ZmlsZV9tdWx0aWJsb2NrX3JlYWRfY291bnQgcGFyYW1ldGVyPC9USVRMRT4NCjwvSEVBRD4NCjxC
T0RZPg0KDQo8UD48Rk9OVCBTSVpFPTI+VGhlcmUgaXMgbm8gc2Vuc2UgdG8gbWFrZSB0aGlzIHBh
cmFtZXRlciBtb3JlIHRoZW4gbWF4IElPIHNpemUgZm9yIE9TLiBGb3Igc29sYXJpcyBiZWZvcmUg
Mi43IGl0IGlzIDY0SywgYWZ0ZXIgdGhhdCBpdCBpcyBjb25maWd1cmFibGUgaW4gL2V0Yy9zeXN0
ZW0uIERvIG5vdCByZW1lbWJlciB3aGF0IGlzIG1heGltdW0sIGJ1dCBub3QgbGVzcyB0aGVuIDEy
OEsuPC9GT05UPjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPkFsZXggSGlsbG1hbjwvRk9OVD4NCjwv
UD4NCg0KPFA+PEZPTlQgU0laRT0yPi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tPC9GT05UPg0K
PEJSPjxGT05UIFNJWkU9Mj5Gcm9tOiBHYWphIEtyaXNobmEgVmFpZHlhbmF0aGEgWzxBIEhSRUY9
Im1haWx0bzpnYWphdkB5YWhvby5jb20iPm1haWx0bzpnYWphdkB5YWhvby5jb208L0E+XTwvRk9O
VD4NCjxCUj48Rk9OVCBTSVpFPTI+U2VudDogV2VkbmVzZGF5LCBKdWx5IDEyLCAyMDAwIDc6MzYg
UE08L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPlRvOiBNdWx0aXBsZSByZWNpcGllbnRzIG9mIGxp
c3QgT1JBQ0xFLUw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPlN1YmplY3Q6IFJlOiBkYl9maWxl
X211bHRpYmxvY2tfcmVhZF9jb3VudCBwYXJhbWV0ZXI8L0ZPTlQ+DQo8L1A+DQo8QlI+DQoNCjxQ
PjxGT05UIFNJWkU9Mj5QcmFzYWRhLDwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPkl0
IGlzIGEgZHluYW1pYyBwYXJhbWV0ZXIgdGhhdCBjYW4gYmUgbW9kaWZpZWQgdXNpbmcgYW4gJnF1
b3Q7YWx0ZXI8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPnN5c3RlbSZxdW90OyBvciBhbiAmcXVv
dDthbHRlciBzZXNzaW9uJnF1b3Q7IGFzIHRoZSBjYXNlIG1heSBiZS48L0ZPTlQ+DQo8L1A+DQoN
CjxQPjxGT05UIFNJWkU9Mj5DaGVlcnMsPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+
R2FqYS48L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj4tLS0gUHJhc2FkYSBSIEd1bmRh
ICZsdDtQcmFzYWRhLkd1bmRhMUBoYXJ0Zm9yZGxpZmUuY29tJmd0OyB3cm90ZTo8L0ZPTlQ+DQo8
QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9O
VD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBIaSBBbGwsPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9
Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBXZSBhcmUgdXNpbmcgRVRMKGV4
dHJhY3Rpb24sdHJhbnNmb3JtYXRpb24gYW5kIGxvYWRpbmcpIHRvb2w8L0ZPTlQ+DQo8QlI+PEZP
TlQgU0laRT0yPiZndDsgdG8gbG9hZCBkYXRhIGZyb208L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y
PiZndDsgc291cmNlIGRhdGFiYXNlcyB0byB3YXJlaG91c2UgZGF0YWJhc2UuPC9GT05UPg0KPEJS
PjxGT05UIFNJWkU9Mj4mZ3Q7IFRoaXMgdG9vbCBhbGxvd3MgdXMgdG8gd3JpdGUgY3VzdG9tIHNx
bCBhbmQgZG9lcyBub3QgYWxsb3cgRERMPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IHN0
YXRlbWVudHMuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9O
VCBTSVpFPTI+Jmd0OyBJIGFtIHVzaW5nIGZ1bGwgdGFibGUgc2NhbiBvbiBzb21lIG9mIHRoZSB0
YWJsZXMgaW4gc29tZSBzcWw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgcXVyaWVzLiZu
YnNwOyBJIHdvdWxkPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IGxpa2UgdG8gaW5jcmVh
c2UgdGhlIHZhbHVlIG9mIGRiX2ZpbGVfbXVsdGlibG9ja19yZWFkX2NvdW50PC9GT05UPg0KPEJS
PjxGT05UIFNJWkU9Mj4mZ3Q7IHdoZW4gSSBkbyBGVFMuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9
Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBJcyB0aGVyZSBhbnkgd2F5IEkg
Y291bGQgaW5jcmVhc2UgdGhlPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IGRiX2ZpbGVf
bXVsdGlibG9ja19yZWFkX2NvdW50Jm5ic3A7IHZhbHVlIG90aGVyPC9GT05UPg0KPEJSPjxGT05U
IFNJWkU9Mj4mZ3Q7IHRoYW4gY2hhbmdpbmcgaXQgaW4gaW5pdC5vcmEgZmlsZS48L0ZPTlQ+DQo8
QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IFRoYW5r
cyBpbiBhZHZhbmNlIGZvciB5b3VyIGhlbHAuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7
IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBSZWdhcmRzLDwvRk9OVD4NCjxCUj48Rk9O
VCBTSVpFPTI+Jmd0OyBQcmFzYWQ8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05U
Pg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyAt
LSA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgQXV0aG9yOiBQcmFzYWRhIFIgR3VuZGE8
L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsmbmJzcDsmbmJzcDsgSU5FVDogUHJhc2FkYS5H
dW5kYTFAaGFydGZvcmRsaWZlLmNvbTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZP
TlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgRmF0IENpdHkgTmV0d29yayBTZXJ2aWNlcyZuYnNw
OyZuYnNwOyZuYnNwOyAtLSAoODU4KSA1MzgtNTA1MSZuYnNwOyBGQVg6ICg4NTgpPC9GT05UPg0K
PEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDUzOC01MDUxPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4m
Z3Q7IFNhbiBEaWVnbywgQ2FsaWZvcm5pYSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu
YnNwOyZuYnNwOyAtLSBQdWJsaWMgSW50ZXJuZXQgYWNjZXNzIC88L0ZPTlQ+DQo8QlI+PEZPTlQg
U0laRT0yPiZndDsgTWFpbGluZyBMaXN0czwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0Ozwv
Rk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08L0ZPTlQ+DQo8QlI+PEZPTlQgU0la
RT0yPiZndDsgVG8gUkVNT1ZFIHlvdXJzZWxmIGZyb20gdGhpcyBtYWlsaW5nIGxpc3QsIHNlbmQg
YW4gRS1NYWlsPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IG1lc3NhZ2U8L0ZPTlQ+DQo8
QlI+PEZPTlQgU0laRT0yPiZndDsgdG86IExpc3RHdXJ1QGZhdGNpdHkuY29tIChub3RlIEVYQUNU
IHNwZWxsaW5nIG9mICdMaXN0R3VydScpPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IGFu
ZCBpbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyB0aGUgbWVzc2FnZSBCT0RZLCBpbmNs
dWRlIGEgbGluZSBjb250YWluaW5nOiBVTlNVQiBPUkFDTEUtTDwvRk9OVD4NCjxCUj48Rk9OVCBT
SVpFPTI+Jmd0OyAob3IgdGhlIG5hbWUgb2YgbWFpbGluZyBsaXN0IHlvdSB3YW50IHRvIGJlIHJl
bW92ZWQgZnJvbSkuIDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBZb3UgbWF5PC9GT05U
Pg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IGFsc28gc2VuZCB0aGUgSEVMUCBjb21tYW5kIGZvciBv
dGhlciBpbmZvcm1hdGlvbiAobGlrZTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+c3Vic2NyaWJp
bmcpLjwvRk9OVD4NCjwvUD4NCjxCUj4NCg0KPFA+PEZPTlQgU0laRT0yPj09PT09PC9GT05UPg0K
PEJSPjxGT05UIFNJWkU9Mj5HYWphIEtyaXNobmEgVmFpZHlhbmF0aGE8L0ZPTlQ+DQo8QlI+PEZP
TlQgU0laRT0yPkRpcmVjdG9yLCBJLU8gTWFuYWdlbWVudCBQcm9kdWN0czwvRk9OVD4NCjxCUj48
Rk9OVCBTSVpFPTI+UXVlc3QgU29mdHdhcmUgSW5jLiA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y
Pig5NzIpLTMwNC0xMTcwPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5nYWphdkB5YWhvby5jb208
L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj4mcXVvdDtPcGluaW9ucyBhbmQgdmlld3Mg
ZXhwcmVzc2VkIGFyZSBteSBvd24gYW5kIG5vdCBvZiBRdWVzdCZxdW90OzwvRk9OVD4NCjwvUD4N
Cg0KPFA+PEZPTlQgU0laRT0yPl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5EbyBZb3UgWWFob28hPzwvRk9O
VD4NCjxCUj48Rk9OVCBTSVpFPTI+R2V0IFlhaG9vISBNYWlsIC0gRnJlZSBlbWFpbCB5b3UgY2Fu
IGFjY2VzcyBmcm9tIGFueXdoZXJlITwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+PEEgSFJFRj0i
aHR0cDovL21haWwueWFob28uY29tLyIgVEFSR0VUPSJfYmxhbmsiPmh0dHA6Ly9tYWlsLnlhaG9v
LmNvbS88L0E+PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4tLSA8L0ZPTlQ+DQo8QlI+PEZPTlQg
U0laRT0yPkF1dGhvcjogR2FqYSBLcmlzaG5hIFZhaWR5YW5hdGhhPC9GT05UPg0KPEJSPjxGT05U
IFNJWkU9Mj4mbmJzcDsgSU5FVDogZ2FqYXZAeWFob28uY29tPC9GT05UPg0KPC9QPg0KDQo8UD48
Rk9OVCBTSVpFPTI+RmF0IENpdHkgTmV0d29yayBTZXJ2aWNlcyZuYnNwOyZuYnNwOyZuYnNwOyAt
LSAoODU4KSA1MzgtNTA1MSZuYnNwOyBGQVg6ICg4NTgpIDUzOC01MDUxPC9GT05UPg0KPEJSPjxG
T05UIFNJWkU9Mj5TYW4gRGllZ28sIENhbGlmb3JuaWEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsmbmJzcDsgLS0gUHVibGljIEludGVybmV0IGFjY2VzcyAvIE1haWxpbmcgTGlz
dHM8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPC9GT05UPg0KPEJSPjxGT05U
IFNJWkU9Mj5UbyBSRU1PVkUgeW91cnNlbGYgZnJvbSB0aGlzIG1haWxpbmcgbGlzdCwgc2VuZCBh
biBFLU1haWwgbWVzc2FnZTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+dG86IExpc3RHdXJ1QGZh
dGNpdHkuY29tIChub3RlIEVYQUNUIHNwZWxsaW5nIG9mICdMaXN0R3VydScpIGFuZCBpbjwvRk9O
VD4NCjxCUj48Rk9OVCBTSVpFPTI+dGhlIG1lc3NhZ2UgQk9EWSwgaW5jbHVkZSBhIGxpbmUgY29u
dGFpbmluZzogVU5TVUIgT1JBQ0xFLUw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPihvciB0aGUg
bmFtZSBvZiBtYWlsaW5nIGxpc3QgeW91IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4mbmJzcDsg
WW91IG1heTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+YWxzbyBzZW5kIHRoZSBIRUxQIGNvbW1h

Received on Thu Jul 13 2000 - 08:00:24 CDT