An Oracle blog – Amardeep Sidhu

June 10, 2008

A database – one tablespace & one datafile

Filed under: Oracle General — Sidhu @ 9:32 pm
Tags:

Today I was checking OTN forums and came across a thread. OP’s concern was:

One of the db i am supporting has about 3.3 Terabytes capacity and the application is using only 1 huge tablespace with one big file.

the system is linux 4 , 32 bit.
oracle version is 10.2.0.4

Is there a limit of space for a tablespace when you consider insert/delete/query performance?

Single datafile of 3.3 TB 🙂

Awesome !

Kudos to the designer 😉

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Theme: Rubric. Get a free blog at WordPress.com

%d bloggers like this: