Database Administration (MOSC)

MOSC Banner

Table size and Tablespace size and Overall Database Size

edited May 28, 2013 7:37PM in Database Administration (MOSC) 9 commentsAnswered
Hello to all,

We have made one generalize standard for tablespaces size for each and every production database initially...

so every database got same tablespace size intially and as when needed the datafiles extended by autoextend clause....

But from few years we are facing problem that at some sites in production database  datafiles of tablespaces got full and we have to add new datafile into those tablespaces to accomodate data..

But i want to make standard tablespace size which can accomodate data of some duration.

So is there any documents or note that how can we calculate standard tablespace size (according to the application usages)? Individual table's actual occupied size and ratio of increment of table 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