Estimated dB size if BLOB data type is included [message #464345] |
Wed, 07 July 2010 08:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
![vyer.atarom@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Sir/ Ma'am,
We will create a new instance in our production server, but this time, part of it's table structure has a BLOB data type (re: <column name> blob(3000)). It's our first time to handle this kind of Oracle data type. What would be my estimate size for it's default tablespace?
Regards.
|
|
|
|
|
Re: Estimated dB size if BLOB data type is included [message #464369 is a reply to message #464358] |
Wed, 07 July 2010 10:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:If blob doesn't have any size, what would be my initial size for it's default tablespace?
Initial size of what? Use LMT with auto-allocate management and do not care about table initial size. Now for your tablespace(s) initial size, only you can answer how many data you will have.
Quote:AND what would be my db_block_size then?
It depends on your usage (and it is more tablespace block size than db_block_size).
See:
Database Concepts, Chapter 3 "Tablespaces, Datafiles, and Control Files", Section "Multiple Block Sizes" (and its links)
Database Performance Tuning Guide
Chapter 8 "I/O Configuration and Design"
Section 8.2.6 "Choosing Data Block Size"
Regards
Michel
[Updated on: Wed, 07 July 2010 10:22] Report message to a moderator
|
|
|
|
Re: Estimated dB size if BLOB data type is included [message #464416 is a reply to message #464408] |
Thu, 08 July 2010 00:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Make create a bigfile tablepspace with autoextend on and maxsize unlimited. Assign it as default tablespace for the particular user or set it as default tablespace for all user
I don't think it is wise for any case.
1/ No disk has unlimited available space
2/ Why putting all data, blobs, and any segments of all users in only one tablespace?
3/ Why a bigfile tablespace?
...
A quite peremptory advice.
Regards
Michel
|
|
|