Database Administration (MOSC)

MOSC Banner

Estimating initial tablespace size

edited May 3, 2013 3:50AM in Database Administration (MOSC) 10 commentsAnswered
I need to create a new tablespace in one of the databases and I wanted to see if there are best practices for estimating an initial tablespace size.

I looked at an existing tablespace that is serving similar purpose and the size of such tablespace is about 25000M (size of all its datafiles) and block-size is 32768.


SELECT TABLESPACE_NAME, SUM(BYTES)/1024/1024 AS TBS_SIZE
       FROM DBA_DATA_FILES
       WHERE TABLESPACE_NAME ='TABLESPACE1'
GROUP BY TABLESPACE_NAME;

based on this information how cand I figure out the best initial tablespace size?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center