Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: db_block_size and performance

Re: db_block_size and performance

From: Thomas Pall <tpall_at_bga.com>
Date: 31 Oct 98 21:25:25 GMT
Message-ID: <363b8045.0@feed1.realtime.net>


Sorry, Chuck. I assumed that. Making the block size smaller than the OS block size will slow you down for sure.

Chuck Hamilton (chuckh_at_safeaccess.net) wrote:
: This is a cryptographically signed message in MIME format.

: --------------ms2D5D5302EEACB6E548D9A388
: Content-Type: text/plain; charset=us-ascii
: Content-Transfer-Encoding: 7bit

: >
: > There is no hard and fast rule about how big a db_block_size to use. It
: > depends on your application.

: Actually there is one hard and fast rule -- make sure the block size is a
: multiple of the OS block size. Otherwise you'll end up issuing multiple OS calls
: to read the same physical block of data.

: We had an OLTP Oracle database running on Netware. It was installed with the
: default 2k block size even though the OS block size was 8k. We increased the DB
: block size to 8k and saw a significant performance increase.

: Chuck Hamilton

: --------------ms2D5D5302EEACB6E548D9A388
: Content-Type: application/x-pkcs7-signature; name="smime.p7s"
: Content-Transfer-Encoding: base64
: Content-Disposition: attachment; filename="smime.p7s"
: Content-Description: S/MIME Cryptographic Signature

: MIIHpgYJKoZIhvcNAQcCoIIHlzCCB5MCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
: BckwggKIMIIB8aADAgECAgJGPDANBgkqhkiG9w0BAQQFADCBuTELMAkGA1UEBhMCWkExFTAT
: BgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRo
: YXd0ZSBDb25zdWx0aW5nMSkwJwYDVQQLEyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAx
: Nzo1NTE2MDQGA1UEAxMtVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5
: OC45LjE2MB4XDTk4MTAyNzE3MTQyNFoXDTk5MTAyNzE3MTQyNFowRzEfMB0GA1UEAxMWVGhh
: d3RlIEZyZWVtYWlsIE1lbWJlcjEkMCIGCSqGSIb3DQEJARYVY2h1Y2toQHNhZmVhY2Nlc3Mu
: bmV0MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALKGbsEBBYR8bbdnNn5i/v2q29pixSiPshCO
: R9qFgkeJPv4Gpv8NApxGz/Kf+RkJbi88+PlMuLssSLJhber5lXMCAwEAAaNUMFIwEQYJYIZI
: AYb4QgEBBAQDAgWgMA4GA1UdDwEB/wQEAwIFoDAMBgNVHRMBAf8EAjAAMB8GA1UdIwQYMBaA
: FP4+YJxrjA+w2DPGysYeWLBxOLXgMA0GCSqGSIb3DQEBBAUAA4GBADN4ltaKS0WYAGaWTZ+0
: tjb9w3dJ3hs6nw26HZx3uabGsrBB2CXFrx0RgMugbn4eK93XVzLtmtPO0Lkf59FKN5BmpK5s
: 0Goe7smMP3q7MOfr9NdYwuK6z8HYEbkZ4qnmdKcfW5hPCtSeMK0v8ArLRjS+35eRgdSb5qx9
: QWiCZfdFMIIDOTCCAqKgAwIBAgIBCjANBgkqhkiG9w0BAQQFADCB0TELMAkGA1UEBhMCWkEx
: FTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFU
: aGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZp
: c2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcN
: AQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTk4MDkxNjE3NTUzNFoXDTAw
: MDkxNTE3NTUzNFowgbkxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxFDAS
: BgNVBAcTC0R1cmJhbnZpbGxlMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEpMCcGA1UE
: CxMgVGhhd3RlIFBGIFJTQSBJSyAxOTk4LjkuMTYgMTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQ
: ZXJzb25hbCBGcmVlbWFpbCBSU0EgSXNzdWVyIDE5OTguOS4xNjCBnzANBgkqhkiG9w0BAQEF
: AAOBjQAwgYkCgYEAxKXl1NTQXwgC7gchfSS/q2uOHusgBwIVhGuP0JMkHxud7miyuSxP6ZNn
: FxAXHqH5Q0EjuTCqdpe78+f9gcC1MYv2plAmVPKVKOsZpB6XHrDiuJvBBJoy0DwJbE/kNU/w
: dr8AEwNPRQhg8/y00JABihLJnLp/UuoqkzU2PDzkNS8CAwEAAaM3MDUwEgYDVR0TAQH/BAgw
: BgEB/wIBADAfBgNVHSMEGDAWgBRyScJzNMZV9At2coF+d/SH58ayDjANBgkqhkiG9w0BAQQF
: AAOBgQAsx4IfAUM+B4/uaVypZIL4wJatkyvLm1DXQJqBwrqmdp08lUDcVcHhVYJ5qwopptUM
: 4VcoPo/5u9XfDZNYqlsti48z5N1YFTV2chUpvUL0WpILd1+dJ9uaLU4bggaO0o1Wu5Xe2wxl
: Bd6VngLdUxe+vvxrwxoiehQrYb3Cn156WjGCAaUwggGhAgEBMIHAMIG5MQswCQYDVQQGEwJa
: QTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRQwEgYDVQQHEwtEdXJiYW52aWxsZTEaMBgGA1UE
: ChMRVGhhd3RlIENvbnN1bHRpbmcxKTAnBgNVBAsTIFRoYXd0ZSBQRiBSU0EgSUsgMTk5OC45
: LjE2IDE3OjU1MTYwNAYDVQQDEy1UaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgUlNBIElzc3Vl
: ciAxOTk4LjkuMTYCAkY8MAkGBSsOAwIaBQCgfTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcB
: MBwGCSqGSIb3DQEJBTEPFw05ODEwMjkxMzIwMjBaMB4GCSqGSIb3DQEJDzERMA8wDQYIKoZI
: hvcNAwICASgwIwYJKoZIhvcNAQkEMRYEFOw26K76xvErr+8IF07Q7usJk9eEMA0GCSqGSIb3
: DQEBAQUABEAZyNdEa0fXjczTpcg7Z+YA6a7QIFg2Xr1i3nba6LUgpAHCMF3OplKS6+WhYstF
: Nf6Jr2O9+ZKDqa2uQ8ua12hX
: --------------ms2D5D5302EEACB6E548D9A388--

-- Received on Sat Oct 31 1998 - 15:25:25 CST

Original text of this message

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