Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Multiple Block Size
gauravdba
post Apr 6 2004, 05:10 AM
Post #1


Newbie
*

Group: Members
Posts: 5
Joined: 2-April 04
Member No.: 79



Hi, I have a question about multiple block sizes availabe in Oracle9i
What is the advantage of having multiple block sizes?
and
Why we can not assign multiple block sizes to temporary tablespaces?
Go to the top of the page
 
+Quote Post
burleson
post Apr 6 2004, 06:08 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,400
Joined: 26-January 04
Member No.: 13



Hi Grarav,

Multiuple blocksizes are GREAT, but ONLY if your database is I/O-bound. Check your top-5 STATSPACK timed events first.

Also, you must ensure that your database is using direct I/O:

http://www.dba-oracle.com/oracle_tips_direct_io.htm

The performence benefits are obvious, and most of the world-record Oracle benchmarks used multiple blocksizes:

http://www.dba-oracle.com/oracle_tips_benchmarks.htm

Finally, research has proved that Oracle indexes build cleaner in large blocksizes:

http://www.dba-oracle.com/oracle_tips_index_io.htm

As for the TEMP tablespace, many Oracle DBAs use a default 32k tablespace to get around this issue.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 21st August 2014 - 06:56 PM