| russho |
Posted: Jan 15, 2007 06:53:25 AM |
Total Post: 19
Joined: Oct, 2004
|
Hi All,
Now Oracle database can support multiple data block size,
Please let me know how it will be implemented in a database.
Thanks
Russho
|
|
|
 Jayanta |
| Posted: Jan 15, 2007 12:23:49 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
to explain in brief about multiple block size support in oracle 9i, i first like to say that block sizes can have any power of two value between 2kb to 32 kb. in addition to standard block size defined by db_block_size parameter u can define a max of 4 other non-standard block size to facilitate transporting a tablespace from oltp to enterprise data warehouse or when u require the ability to locate objects of appropriate block size in order to maximise i/o performence.
non standard block sizes are defined by BLOCKSIZE parameter of create tablespace .... statement. e.g create tablespace jayanta datafile 'k:\jay.dbf' size 100m
extent management local uniform size 128 k
blocksize 8k;
here 8k is non standard block size, if db_block_size is not set at 8kb(in bytes). to successfully create a non-standard block size u should define one db_nk_cache_size within db_cache_size and the value of n should be equal to the non-standard block size.
but remember u cant define db_nk_cache_size with value of n equal to standard block size defined by db_block_size. standard block size cant be altered without re creation of database.
by default db_nk_block_size parameter is set to zero.
oracle blocks are multiple of os block.
a specific no of contiguous blocks make extents. which r allocated to tablespaces.
a set of extents make a segment, and segments are allocated to objects like non-partitioned tables, indexes etc.
and these blocks, extents, segments, tablespaces r all the logical parts of oracle database
hope this will help
with regards
jayanta
|
|
|
|
|
| Jayanta |
| Posted: Jan 15, 2007 12:26:48 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
standard block size is used for system and temporary tablespaces.
though other tablespaces can also use standard block size.
|
|
|
|
|
| Vigyan |
| Posted: Jan 15, 2007 04:32:07 PM | |
|
Total Post: 386
Joined: May, 2001
|
Good explanation Jayanta!
Thanks,
Vigyan
|
|
|
|
|
| Jayanta |
| Posted: Jan 16, 2007 06:15:55 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
hello vigyan
thanks a lot for ur encouragement. i am learning oracle. so now i will learn it with more enthu.
with regards
jayanta
|
|
|
|
|
| russho |
| Posted: Jan 19, 2007 07:08:08 AM | |
|
Total Post: 19
Joined: Oct, 2004
|
Hi,
Thanks a lot guys u have made every single points v v clear indeed.
Thanks again.
Rgds
Russho
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
