Re: Bigger block sizes

Sent from Nine<http://www.9folders.com/>

From: Kevin Jernigan <kevin.jernigan_at_oracle.com> Sent: Oct 1, 2015 4:59 PM
To: Sheehan, Jeremy; contact_at_soocs.de; oracle-l_at_freelists.org; oralrnr_at_gmail.com Subject: Re: Bigger block sizes

With BasicFiles or SecureFiles? -KJ

--
Kevin Jernigan
Senior Director Product Management
Advanced Compression, Hybrid Columnar
Compression (HCC), Database File System (DBFS), SecureFiles, Database Smart Flash Cache, Total Recall, Database Resource
Manager (DBRM), Direct NFS Client (dNFS), Continuous Query Notification (CQN),
Index Organized Tables (IOT), Information Lifecycle Management (ILM)
+1-650-607-0392 (o)
+1-415-710-8828 (m)

On 10/1/15 9:17 AM, Sheehan, Jeremy wrote:
> Orlando,
>
> I did testing and implemented a BLOB tablespace with 32K blocksize and I saw about a 20% increase in performance when saving and retrieving files into a blob column.
>
> Jeremy
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stefan Koehler
> Sent: Thursday, October 01, 2015 12:03 PM
> To: oracle-l_at_freelists.org; oralrnr_at_gmail.com
> Subject: Re: Bigger block sizes
>
> This is an EXTERNAL email. Exercise caution. DO NOT open attachments or click links from unknown senders or unexpected email.
>
> ________________________________
>
>
> Hi Orlando,
> it depends (as always).
>
> Franck Pachot has written a great blog post with several demos about this topic: http://blog.dbi-services.com/do-the-block-size-matter/
>
> Best Regards
> Stefan Koehler
>
> Freelance Oracle performance consultant and researcher
> Homepage: http://www.soocs.de
> Twitter: _at_OracleSK
>
>> Orlando L <oralrnr_at_gmail.com> hat am 30. September 2015 um 23:29 geschrieben:
>>
>> List,
>>
>> Does anyone in the list use non default blocksize of greater than 8K for your oracle DBs; if so, is it for warehousing/OLAP type applications?
>> What advantages do you get with them; any disadvantage.
>>
>> Orlando.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> ��i��0���zX���+��n��{�+i�^l===

--
http://www.freelists.org/webpage/oracle-l