OraFAQ Forum: Server Administration » Estimated dB size if BLOB data type is included

Home » RDBMS Server » Server Administration » Estimated dB size if BLOB data type is included (Oracle 10g R2, 10.2.0.4.0, Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Estimated dB size if BLOB data type is included [message #464345]

Wed, 07 July 2010 08:06

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

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.

Report message to a moderator

Re: Estimated dB size if BLOB data type is included [message #464348 is a reply to message #464345]

Wed, 07 July 2010 08:10

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

(re: <column name> blob(3000))

Wrong statement. A BLOB does NOT have a size.

Quote:

What would be my estimate size for it's default tablespace?

The size you ussually calculate plus the sum of the binary data you will store.

Regards
Michel

Report message to a moderator

Re: Estimated dB size if BLOB data type is included [message #464358 is a reply to message #464345]

Wed, 07 July 2010 08:47

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Many thanks with this info.. and your prompt reply!

If blob doesn't have any size, what would be my initial size for it's default tablespace? Is 2Gb enough + it's other datafiles?

AND what would be my db_block_size then?

Report message to a moderator

Re: Estimated dB size if BLOB data type is included [message #464369 is a reply to message #464358]

Wed, 07 July 2010 10:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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 #464408 is a reply to message #464345]

Wed, 07 July 2010 23:40

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

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 any option as per your requirement.

Regards
Deepak

[Updated on: Wed, 07 July 2010 23:57]

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Problem in Installtion
Next Topic:	buffer cache

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 13:18:54 CST 2024